When filtering a table or a matrix in reporting services you might encounter the following error:
Cannot compare data types of System.Int32 and System.String. Please check the data type returned by the filter expression.
This happens when the column to be filtered is of type numeric (integer in our case) and you try to compare it with a number. The correct way to do it is like in the picture below:
In the value field put another “=” sign otherwise the number will be interpreted as a string and not as a number.
Find all views, stored procedures etc that use a table column
SELECT OBJECT_NAME(sd.id) Dependent_Object,
(SELECT xtype FROM sysobjects so WHERE so.id = sd.id) Object_Type
FROM sysobjects so
INNER JOIN syscolumns sc ON so.id = sc.id
INNER JOIN sysdepends sd ON so.id = sd.depid AND sc.colid = sd.depnumber
WHERE so.id = OBJECT_ID('TABLE_NAME')
AND sc.name = 'TABLE_COLUMN'
Requested registry access is not allowed
After uninstalling Visual Studio 2010 BETA, one of the bugs I received in Visual Studio 2008 was
Requested Registry Access is not allowed while trying to add a class to my solution.
To fix this, download and install SubInACL which is a command line tool. After installing this, create a .bat file and put this lines in it:
subinacl /subkeyreg HKEY_CLASSES_ROOT\VisualStudio.vbproj.9.0 /grant=administrators=f
subinacl /subkeyreg HKEY_CLASSES_ROOT\VisualStudio.vbproj.9.0 /grant=users=f
subinacl /subkeyreg HKEY_CLASSES_ROOT\VisualStudio.vbproj.9.0 /grant=system=f
subinacl /subkeyreg HKEY_CLASSES_ROOT\VisualStudio.csproj.9.0 /grant=administrators=f
subinacl /subkeyreg HKEY_CLASSES_ROOT\VisualStudio.csproj.9.0 /grant=users=f
subinacl /subkeyreg HKEY_CLASSES_ROOT\VisualStudio.csproj.9.0 /grant=system=f
Save the bat file into C:\Program Files\Windows Resource Kits\Tools or Program Files (x86) depending on your system, and run it.
problem fixed!
IIS Media Services inseamna o platforma HTTP care poate face streaming True HD (720p+). Se instaleaza peste IIS 7.
If you add a HyperLinkField to a Grid View and you set the DataNavigateUrlFields to “Email” (the field coming from the database) and the DataNavigateUrlFormat to “mailto:{0}” it wont work, because asp.net does some extra validation and the output is no link.
Read the rest of this entry »
Visual Studio 2010
De astazi puteti descarca Visual Studio 2010 BETA. F# face acum parte oficial din pachet.
Read the rest of this entry »
Visual Studio 2008 Express
Puteti descarca varianta gratuita pentru Visual Studio 2008 (.NET Framework 3.5) accesand acest link. Tot pe aceasta pagina puteti descarca si o varianta light pentru MSDN Library.