[ASP ]Insert語法

[smallallen03 (ai)]

        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