做个结吧.做dataset,但不知道为什么delete不行
If Request.QueryString("repl") = "delete" Then
Dim sqlsele1 As String = "select * from adminsend where adminsm='" & Session("username") & "' and id=" & Request.QueryString("id")
adocmd = New OleDbDataAdapter(sqlsele1, sqlprov)
Dim ds1 As DataSet = New DataSet()
adocmd.Fill(ds1, "adminsend")
mytable = ds1.Tables.Item(0)
mytable.Rows.Item(0).Delete()
cmd = New OleDbCommandBuilder(adocmd)
adocmd.Update(ds1, "adminsend")
Response.Redirect("message.aspx")
If Request.QueryString("repl") = "delete" Then
Dim sqlsele1 As String = "select * from adminsend where adminsm='" & Session("username") & "' and id=" & Request.QueryString("id")
adocmd = New OleDbDataAdapter(sqlsele1, sqlprov)
Dim ds1 As DataSet = New DataSet()
adocmd.Fill(ds1, "adminsend")
mytable = ds1.Tables.Item(0)
mytable.Rows.Item(0).Delete()
cmd = New OleDbCommandBuilder(adocmd)
adocmd.Update(ds1, "adminsend")
Response.Redirect("message.aspx")
如果是SQL语句是:Delete adminsend where adminsm='zc_net' and id='2'
是没错的。