DataGrid中的更新和删除如何操作？

[storm97]

Sub DataGrid_delete(sender As Object,e As DataGridCommandEventArgs)
Dim uscode As String=e.Item.Cells(2).Text
Dim MyConnection As SQLConnection
Dim delcommand As SQLDataAdapter
Dim id As String
id=MyDataGrid.Datakeys.Item(e.item.ItemIndex)
MyConnection= New SQLConnection("server='albert'; uid=sa; pwd=; database=warehouse")
Dim delsql As String = "delete from tbluser where us_id = '" & id & "'"
delcommand = New SQLDataAdapter(delsql, MyConnection)
MyConnection.open()
response.write(id)
response.write("delete from tbluser where us_id = '" & id & "'")
End Sub
SQL语句为什么不执行呢？？？

[storm97]

各位高手赶快来帮忙啊！！
我在线等待！！！！

[龙腾九霄]

你的command没有运行怎么删除呢？
加入这句在MyConnection.open()后面。
Dim delcomand1 as SqlCommand
delcommand1=New SqlCommand(delsql,MyConnection)
delcommand1.ExcuteNonQuery();
祝你成功

[storm97]

各位高手，我在MyConnection.open()后面加了delcommand.ExecuteNonQuery()
但是错误信息是ExceuteNonQuery不是System.Data.SqlClient.SqlDataAdapter的组成员！
怎么回事呀？？ 用delcommand.Execute() 也不可以。
帮帮忙！！
谢谢！

[storm97]

搞定！
谢谢！