I am trying to create a fullyeditable gridview in asp.net 2.0 To accomplish this in 1.1 you would do something like below.
How can this be accomplished in ASP.Net 2.0? I am not sure how to call my query commands etc.
HEre is how i would have done it in the past...
Dim dgi as DataGridItem
For Each dgi in DGWeek.Items
'Read in the Primary Key Field
Dim id as Integer = DGWeek.Items.DataKeys(dgi.ItemIndex))
Dim Tithe as Currency = dgi.FindControl("txtTithe"), TextBox).Text
Dim Education as Currency = dgi.FindControl("txtEducation"), TextBox).Text
'Issue an UPDATE statement...
Dim updateSQL as String = "UPDATE Tithe SET Tithe = @Tithe, " & _
"Education = @Education WHERE TRID = @TRID"