[ASP ]Insert語法
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
討論串 (同標題文章)
以下文章回應了本文:
完整討論串 (本文為第 1 之 2 篇):
Visual_Basic 近期熱門文章
PTT數位生活區 即時熱門文章