Dynamically populate DetailsView Control

[sruvee]

Hi All,

I am using a DetailsView Control to get the data from a SQL Server table. I am using all the three operations (EDIT,DELETE,NEW) on the database table through DetailsView.
The primary key in the table is EmployeeID. My requirement is whenever user click on NEW, I want to get the maximum employee ID from table, and I want to increment it by 1. I would like to display this employee ID , whenever user wants to insert a new record. And also I want to make this text box read only. Where I have to put the code to do this task?
How can I achieve this?

Thanks & Happy new year to all of you

Sruvee

 

[ca8msm]

Why don't you just use an IDENTITY column in your SQL server table?


-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]

 

[sruvee]

Even, if I use IDENTITY column in SQL table, I don't know how to bind this with the DetailsView ctrl's EmployeeID text box.
Could any body tell me how to do that?

 

[ca8msm]

You return it by using scope_identity() once the record has been inserted. You can then just bind it to any control you want.


-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]