When you use a Webform DataGrid, you need to "roll" your own code and perform postbacks to have the selected row change. You can have an Edit button for each row that turns the row into a state that the users can apply updates. To see an example, refer to my whitepaper and download the sample code for the OLEDB sample. The way of performing the update would be the same for SQL Server, you would just use the SQL Server managed provider instead. Here is the link:
Whitepaper:
http://msdn.microsoft.com/library/?url=/library/en-us/dnfoxgen7/html/usingaspnetwithvfp7.aspDownload for the OLEDB sample:
http://www.gotdotnet.com/team/vfp/downloads/VFP7OLEDBExampleVB.zip>I've gotta be missing something simple, but I have a datagrid on a Web form that is bound to a SQL server table. The data displays fine in the grid, but when I click on a cell, it does not appear to be selected. I programmatically set the selected index to 5 initially (and that row appears selected), then click on a different row. No change in the appearance of the grid, and the selected index is still 5. What am I missing? (Columns are NOT read only).
>
>TIA,
>Gary
-----------------------------------------
Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.comwww.prenia.comWeblog: blogs.prenia.com/cathi