January 2009 Entries
Aashish Gupta has posted a nice list of shorcuts in Visual Studio. Here's the link: http://smallworkarounds.blo
How to download multiple images (/files) from SQL Server to client using ASP.NET and DotNetZip? Here is a simple way you can use to let your web site users download multiple images or files at once. For this article, I will be focused on images but the same technique can be used for downloading files also. I will be describing how to zip all the images in a folder and send the zipped file to the client. In my case, the images were stored in SQL Server as binary data so I had to come up with a process...
There might be other reasons for this error but this is what I found out: You might get the error when you have a databound AJAX reorderlist and you are trying to persist the reordering using database. The SELECT and UPDATE methods should have the same number of fields, even if they are not used in UPDATE, the signature of both the methods should be matching else you will get this error. Here is very good article on how to use AJAX Reorderlist with ObjectDataSource by Justin Saraceno. http://weblogs.asp.net/just...
Scenario - My stored procedure just returns some integer values depending on different conditions. There are no OUT or any other parameters involved for returning values from the stored procedure. e.g. IF (EXISTS( SELECT * FROM TableName WHERE UserId = @UserId AND RoleId = @RoleId)) RETURN(1) ELSE RETURN(0) If you notice, there are no output parameters involved here. The return value can be accessed from code (C# for example), like this: SqlParameter returnValueParam = command.Parameters.Add("@re...