web程式中datagrid更新不成的问题

[sz_lgp]

这是web程式中修改数据行后更新的过程，程式执行通过，但是数据没有更新，好象是str1取得的数据没有变，是更新以前各列的值的，不知问题出在哪里？请各位指点（小弟以前是写WINFORM的，对WEB不熟识。）


Private Sub DataGrid1_UpdateCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid1.UpdateCommand
Dim editrownumber As Integer

Dim i As Integer

Dim inputcontrol As TextBox 'Object

editrownumber = DataGrid1.EditItemIndex

Dim rowindex As Integer

Dim myrow As DataRow

rowindex = editrownumber + DataGrid1.CurrentPageIndex * DataGrid1.PageSize

myrow = mytable.Rows(rowindex)

Dim str1 As String

For i = 2 To e.Item.Cells.Count - 1

inputcontrol = e.Item.Cells(i).Controls(0)

str1 = inputcontrol.Text

myrow(i - 2) = str1

' Stop

Next


DataGrid1.EditItemIndex = -1


DataGrid1.DataSource = mytable

DataGrid1.DataBind()
End Sub

[copico]

你要设置datagrid1.updatecommand
用commandBuilder来设置

[gezichong]

daCustomers = New SqlClient.SqlDataAdapter("更新的查询", dcNorthwind)
daCustomers.Fill(dsNorthwind1, "Customers")

Dim cb As SqlClient.SqlCommandBuilder
cb = New SqlClient.SqlCommandBuilder(daCustomers)

[sz_lgp]

commandBuilder在哪里？datagrid1.updatecommand 要怎么设置？

[wangchong]

我的程序

Dim frSR As TextBox = e.Item.Cells(2).Controls(0)
Dim toSR As TextBox = e.Item.Cells(3).Controls(0)

dcSRdt.Rows(e.Item.ItemIndex).Delete()
Dim dr As DataRow = dcSRdt.NewRow()
dr(0) = frSR.Text
dr(1) = toSR.Text
dcSRdt.Rows.Add(dr)
dcSRdt.AcceptChanges()
DGDCSR.EditItemIndex = -1
DGDCSR.DataSource = dcSRdt
DGDCSR.DataBind()

[sz_lgp]

这里得不到修改后的值？

For i = 2 To e.Item.Cells.Count - 1

inputcontrol = e.Item.Cells(i).Controls(0)

str1 = inputcontrol.Text

myrow(i - 2) = str1

' Stop

Next

[sz_lgp]

好象是一样的操作原理。