[ASP ]Insert語法

看板Visual_Basic作者 (ai)時間19年前 (2006/01/07 05:47), 編輯推噓0(000)
留言0則, 0人參與, 最新討論串1/2 (看更多)
Dim name1 As String = Me.TextBox1.Text Dim name2 As String = Me.TextBox2.Text Dim name3 As String = Me.TextBox3.Text Dim name4 As String = Me.TextBox4.Text Dim MyConnection As OleDbConnection Dim MyCommand As OleDbCommand Dim String1 As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = " & Server.MapPath("good.mdb") MyConnection = New OleDbConnection(String1) MyConnection.Open() Dim check As String check = "Insert into goodman(good,good2,good3,good4)values('" & name1 & "','" & name2 & "','" & name3 & "','" & name4 & "')" Dim cmd As New OleDbCommand(check, MyConnection) cmd.ExecuteNonQuery() MyConnection.Close() 語法上都沒錯 簡查快一百遍了 就是查不出原因 也找了一堆人看過 為啥新增資料,資料庫都沒有新的一比資料!? 到底是啥原因!? 有人知道嘛qq 是資料庫的問題嘛!? 還是啥設定的問題.... -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 163.25.118.31
文章代碼(AID): #13lkLn45 (Visual_Basic)
討論串 (同標題文章)
文章代碼(AID): #13lkLn45 (Visual_Basic)