作者siaujan (...)
看板Visual_Basic
标题[.NET] 按下button删除资料列
时间Fri Apr 27 22:12:44 2007
我现在是做一个textbox读取会员编号，
按下button1会删掉该笔编号的整列资料
我想说，主要叙述应该只是一行SQL就可以解决的事，
结果动不了orz
ps. button2不用管他..
程式码如下：
==================================================================
Imports System.Data.OleDb
Public Class memberEnter
Dim objDataSet As DataSet
Dim mm As manaMember
Dim cnn1 As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;"
& "Data Source=comicDB.mdb")
Dim cmd1 As New OleDb.OleDbCommand()
Private Sub memberEnter_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
cnn1.Open()
cnn1.Close()
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click
cmd1.CommandText = "DELETE FROM member WHERE ID = 'TextBox1.Text'"
MsgBox("删除完毕", MsgBoxStyle.Information, "讯息提示")
End Sub
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button2.Click
mm = New manaMember()
mm.Show()
mm.TextBox1.Text = TextBox1.Text
Me.Hide()
End Sub
End Class
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 59.113.20.200