URL: http://aspnetpodcast.com/CS11/blogs/asp.net_podcast/archive/2006/10/11/647.aspx This video (screencast) for the podcast is on the subject of the Basics of Building Sql Server 2005 CLR Objects The WMV and MP4 (for video iPod users) files are in the feed.

Last night I gave my presentation at this month's NUFW Meeting . As unprepared as I was, I think it went pretty well. Before showing up for the meeting, I had the slides done, but had no demos at all. This actually turned out pretty well. I decided to just do two demos. One was ASP.NET w/ C# and the...

I talked with a guy from the Data Access Team and picked up something I thought was really interesting so I thought I'd share. Apparently, when .NET was in it's early stages, all value types (Int32, Single, Guid, etc) were Nullable (IsNull Flag), but apparently it was decided that the extra bit on each...

This sample provides a way to avoid full postback of the page, just updating the grid that contains the data. The first step is create the stored procedure, for that I will use CTE (Common Table Expressions), which is a new feature of SQL Server 2005. The stored procedure will query the table from one...

SqlBulkCopy provides simplest and fastest way to copy large amounts of data to SqlServer. Instead of inserting all data row by row, BulkCopy process all data at once, thus making the insertions fast. public void Bulk_Table_CopyTO_Database(DataTable TableToCopy, string SqlTableName) { SqlConnection con...

Recently I got this error when doing a ADO.NET database call using ExecuteReader. Procedure or function expects parameter '@myid' , which was not supplied. Actually, the error is kind of misleading. Why because I clearly adding my parameter @myid to the SqlParameters collection of the SqlCommand. cmd...

If you are an ADO.NET Entity Framework kinda person, here are the latest bits: · Entity Framework Beta 3 runtime · Entity Framework Tools CTP 2 and this update to VS 2008 is needed also . From Wriju's Blog .

Crikey - they've done it again! Red Gate have *yet again* released another stunningly simple product jam packed full of features! http://www.red-gate.com/messageboard/viewtopic.php?t=3592 Download it and have a play!

Well done article , IMO, on securing passwords in a database table. We've been doing this in all of our applications for a while now and it works great.

Spotted this post on ASP.NET and ADO.NET best practices , it's not an exhaustive list, but there is some good advice there.