Sub MyDataGrid_Delete(Sender As Object, E As DataGridCommandEventArgs)
'建立Connection对象
Dim conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPath("data\mdb.mdb"))
'建立Command对象
Dim strSql As String
strSql="Delete from car Where 编号=" & MyDataGrid.DataKeys(CInt(E.Item.ItemIndex))
Dim cmd As New oledbCommand(strSql, conn)
'执行删除操作
conn.Open()
cmd.ExecuteNonQuery()
conn.Close()
'重新绑定
MyDataGrid.EditItemIndex = -1
Call BindData()
End Sub
<ASP:DataGrid id="MyDataGrid" Width="100%" HeaderStyle-BackColor="#799AE1" AllowPaging="True" PageSize="5" OnPageIndexChanged="MyDataGrid_Page" PagerStyle-HorizontalAlign="Right" PagerStyle-Mode="NumericPages" OnEditCommand="MyDataGrid_Edit" OnCancelCommand="MyDataGrid_Cancel" OnUpdateCommand="MyDataGrid_Update" OnDeleteCommand="MyDataGrid_Delete" DataKeyField="编号" AutoGenerateColumns="False" runat="server">
<Columns>
<asp:EditCommandColumn EditText="编辑" UpdateText="更新" CancelText="取消" ItemStyle-Wrap="False"/>
<asp:ButtonColumn Text=&q
数据库表中有一列（TranXml）类型是xml，存储的是类似
<fathernode>
<a>aaa
</a>
<b>bbb
</b>
</fathernode>
的信息，并且通过查询方� ......
