Geeks With Blogs
Mayank Sharma January 2009 Entries
More shortcuts for Visual Studio

Aashish Gupta has posted a nice list of shorcuts in Visual Studio.

Here's the link:

http://smallworkarounds.blogspot.com/2008/12/visual-studio-2008-tips-tricks-for.html

Posted On Wednesday, January 21, 2009 4:25 AM

How to download multiple images (/files) from SQL Server to client using ASP.NET and DotNetZip?
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 ......

Posted On Friday, January 9, 2009 1:20 AM

Reorderlist Error: Reorder failed, see details below. Failed to reorder
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... ......

Posted On Monday, January 5, 2009 1:14 AM

How to get a return value from a Stored Procedure that just returns a value without a parameter
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... ......

Posted On Friday, January 2, 2009 8:08 AM

Copyright © bullpit | Powered by: GeeksWithBlogs.net