looking for example code

[Jon Paal]

--vb.net
--gridview column as dropdownlist
--populated from an array
--match selected value stored in a database for that record displayed in the row

 

[David Wier]

Sorry, this one isn't exact, but it's close - -
http://aspnet101.com/aspnet101/aspnet/codesample.aspx?code=EditDDL_GV

the dropdownlist is populated from a database instead of an array

 

[Jon Paal]

thanks

need a bit more help. my update command is failing to work.

error msg:
Must declare the scalar variable "@userid".

I have the following set:

....asp:SqlDataSource
UpdateCommand="UPDATE UserData SET status = @status WHERE userid = @userid ">

....asp:GridView
DataKeyNames="userid"