Sunday, June 13, 2010

Creating a Data Access Layer (DAL) for ASP.NET and C# Part-3

In the last post I had created a method for INSERT, UPDATE and DELETE with affected rows count. This time I will write same method but a bit difference to previous one. A new method will be created for getting INSERT_ID which creates by Primary Key (Auto Increment).

Here you will find a bit change, even you have to make changes in the SQL Store Procedure too. Lets take a look of Store Procedure.

No comments:

Post a Comment