Need to set Primary Key for insert

[License Developer]

In our environment, we have an AppSequenceNumber table which maintains the next sequence number or primary key for the next insert of each table in the database, and a stored procedure that returns the sequence number and increments it in the database. Therefore, on each record insert for each of our tables, we must call this stored procedure which updates the AppSequenceNumber table and returns the sequence number which we use as our primary key in the record insert. 

In my application, I am using a popup modal window to handle inserts. How do I capture the submit button click event on this form and call the needed stored procedure to update the database sequence number, insert the sequence number as the primary key, and perform the insert?

I am basing my application on the example at: http://demos.telerik.com/aspnet-ajax/controls/examples/integration/gridandwindow/defaultvb.aspx?product=window

Your help is greatly appreciated.
Thank you.

    Chuck 

[Tsvetoslav]

Hello,

Since you are basing your implementation on the example mentioned in your post, I suppose you are using a DetailsView control. If so, just attach an event handler to its ItemCommand event and perform you database operations in it. In the ItemCommand event you have access to all the column field values entered by the user.

Hope it helps.

Greetings,
Tsvetoslav
the Telerik team