關於VB修改的程式碼
哈囉~我想請問
關於VB的修改功能程式碼該如何寫呢
我寫的如下
但跑出來仍有問題
麻煩幫忙看看喔
謝謝
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button2.Click
Dim cnn As OleDbConnection
Dim strcnn As String
strcnn = "Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=""****.accdb"""
'Provider=SQLOLEDB;Data Source=VB work.accdb"
cnn = New OleDbConnection(strcnn)
cnn.Open()
Debug.Print(TextBox2.Text)
Dim cmdstr1 As String = "UPDATE 資料 SET 姓名, 性別,
生日=小玲, F, 2010/1/1, WHERE 編號=3"
Debug.Print(cmdstr1)
Dim cmd As OleDbCommand = New OleDbCommand(cmdstr1, cnn)
cnn.BeginTransaction()
cmd.ExecuteReader(cmdstr1)
cnn.EnlistDistributedTransaction()
End Sub
另外是不是生日的日期造成的呢?
麻煩了
謝謝
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 140.113.73.85
→
08/23 12:54, , 1F
08/23 12:54, 1F
推
08/23 14:16, , 2F
08/23 14:16, 2F
→
08/23 15:35, , 3F
08/23 15:35, 3F
→
08/23 15:36, , 4F
08/23 15:36, 4F
→
08/23 16:47, , 5F
08/23 16:47, 5F
→
08/23 16:48, , 6F
08/23 16:48, 6F
→
08/23 16:49, , 7F
08/23 16:49, 7F
→
08/23 19:20, , 8F
08/23 19:20, 8F
→
08/24 18:46, , 9F
08/24 18:46, 9F
推
08/25 10:55, , 10F
08/25 10:55, 10F
→
08/25 10:56, , 11F
08/25 10:56, 11F