作者yauhh (姚呵呵)
看板Visual_Basic
标题Re: [.NET] datagrid删除资料的问题
时间Sat Jun 14 02:05:04 2008
※ 引述《yukimir (小环)》之铭言：
: Protected Sub dg_DeleteCommand(ByVal source As Object, ByVal e As
: System.Web.UI.WebControls.DataGridCommandEventArgs) Handles dg.DeleteCommand
: Dim con As OleDbConnection
: Dim com As OleDbCommand
: Dim provider = "provider=microsoft.jet.oledb.4.0"
: Dim database = "data source=" & Server.MapPath("db2.mdb")
: con = New OleDbConnection(provider & ";" & database)
: con.Open()
: com.CommandText = "delete from guest where 标题 =" &
: dg.DataKeys(e.Item.ItemIndex)
: com.ExecuteNonQuery()
: con.Close()
: data()
: End Sub
很快地随便看一下这些码,如果你的资料库连线都没问题,
上述 com.CommandText 设定 DELETE 子句是以纯字串方式构成 SQL 句,
在资料库中, guest.标题 栏位是字串类型, SQL 句应该是:
Delete From guest Where 标题 = 'abc'
,如果 dg.DataKeys(e.Item.ItemIndex) 是 'abc'.
写成 com.CommandText 的话, SQL 该有的引号要带进去,应该是
com.CommandText = "delete from guest where 标题 = '" & _
dg.DataKeys(e.Item.ItemIndex) & "'"
做不顺的时候,把 com.CommandText 输出到 Console, 就有线索可检查.
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 218.160.211.217
※ 编辑: yauhh 来自: 218.160.211.217 (06/14 02:07)
1F：推 yukimir:阿...我把guestbook打成guest了= = 我改成你说的样子，不 06/14 12:37
2F：→ yukimir:过还是失败了orz... 06/14 12:38