SqlDataSource identity

[David C]

I have a FormView that has an InsertCommand using a stored procedure (e.g.
"Exec sp_insTable @item1, etc...)
I have a ListBox also on the screen that is tied to the same table and has a
selected value of the ID of the FormView. When I use the FormView in INSERT
mode I would like to set the SelectedValue of the ListBox to the newly
inserted record on the FormView (is the IDENTITY value returned from the
sp). Is there a way to do this? Thanks.

David

 

[Munna]

Hi,

first of all you have to have a output parameter in your sp...
and in sp assign the @@identity to the output param

check out this post...

http://www.velocityreviews.com/foru...ut-parameter-using-sqldatasource-control.html


Best of luck

-------
Munna

www.munna.shatkotha.com/blog
www.munna.shatkotha.com
www.shatkotha.com