Thursday, March 22, 2007

Visual Studio Database Project.

Visual studio 2005 has a lot of project templates when you choose to create a new project. I used mostly library project, windows form project, web project.

The one I used today is visual studio database project. I worked on a state government project which uses a lot of tables, stored procedures.

The database project will allow me to organize all my queries, scripts, stored procedures into one project. It's very neat. Before I started to use that project, I cannot organize all my database scripts very well.  I normally keep all my scripts in one file, and copy one or another to the sql query analyzer. Then I get confused when I have a lot of scripts.

Tuesday, March 20, 2007

Stored procedure debugging error.

I keep getting the following error when debugging a stored procedure.

The strange thing is, every time, when I start the first debug session in visual studio, it's fine, but when I tried the second, third time, it's failing.

I have to restart the Visual studio 2005 Remote Debugger service manually every time I want to step from the code into the stored procedure.

Thursday, March 01, 2007

Finished reading another book.

I just finished reading another book ASP.NET 2.0 Illustrated. This book is a very comprehensive coverage of, but really didn't get into many details. It gives a lot of screen captures, with a lot of MSDN style figures, diagrams explaining different configuration settings.  I would use it more like a reference book.  It doesn't cover more updated features like ajax, which alone probably deserves another book.

If you are a beginner in, this is probably the book for you, but if you have known the very well, you probably will look for another advanced book.