September 2009 Entries

How To: Reset Identity Column Value in SQL Table

Recently, one of the members at forums.asp.net is asking if how to reset identity count in sql table. So I thought of sharing the possible solution that we have discussed in this thread as a reference to others. HTH! Technorati Tags: ASP.NET,SQL,C#...

Good News!: SEA MVPs Blog-A-Holic has Officially Launched Today

Check this out: Technorati Tags: General...

BASIC: Binding ListBox and DropDownList using LINQ

This example shows the basic way on how to populate a data from database to a ListBox/DropDownList control using LINQ to SQL. Note that I used Northwind database here just for the simplicity of this example. To get started then let’s go ahead and add a new item in your website application in Visual Studio 2008 or VWD Express 2008. To do this, just right click on the web site -> select Add New Item -> and on the Templates select LINQ to SQL Classes as shown below and click ok: Now open up Server...