Archive for March, 2007
ASP.NET 2.0 Starter Kits – Password Length Minimum Error
I was getting my hands dirty last evening with the ASP.NET Club Starter Kit. It was pretty neat for the most part that the installation was a piece of cake and bringing it up and running was also a cake walk. But when I tried to create a new member it kept complaining about “Password [...]
Read Full Post | Make a Comment ( 2 so far )Display the text of the stored procedure in SQL Query Analyzer
Ever wanted to just quickly check the stored procedure logic from the SQL Query Analyzer. Here is how you do it,
Open your SQL Query Analyzer
Get to “Tools >> Customize”
Navigate to the “Custom” tab
Pick a shortcut key that’s available (for example, Ctrl + 3)
Type this on the Stored Procedure field “sp_helptext” (without the quotes, of course)
Hit [...]
Visual Studio 2005 Web Service Designer Window
I’m not sure whether this is just me or not but this seems to me like a bug in Visual Studio 2005 (SP1).
When you create an ASP.NET Web Service, Visual Studio, by default, adds the .asmx and .asmx.cs (or .asmx.vb) files. By definition the asmx file is the one which holds the declaration of the service, where the [...]
SQL Server 2005 Service Manager
We all loved SQL Server 2000’s Service Manager, that little application that sits on your system tray and when invoked displays the state of the SQL Server Engine. Do you remember that? For some reason (I don’t know what that is!!!) Microsoft decided to not include that in SQL Server 2005.
So, what? Jasper Smith [...]
Tips and Tricks: Generate Typed Dataset from an XSD file
Visual Studio 2005’s Typed DataSet is pretty cool. It gives you good control of what the relations should be and it pretty much mimics a table in the database. I love it. But one thing I hate about that is when you serialize your Typed DataSet your XML looks not up to the mark of [...]
Read Full Post | Make a Comment ( None so far )Tips and Tricks: Generate Typed Dataset from an XSD file in Visual Studio 2005
Visual Studio 2005’s Typed DataSet is pretty cool. It gives you good control of what the relations should be and it pretty much mimics a table in the database. I love it. But one thing I hate about that is when you serialize your Typed DataSet your XML looks not upto the mark of what [...]
Read Full Post | Make a Comment ( 8 so far )
