bennettfan
Member
- Joined
- Jan 31, 2010
- Messages
- 11
- Programming Experience
- Beginner
Dim str As String = "Provider=Microsoft.Jet.Oledb.4.0;Data source=family.mdb"
Dim conn As OleDbConnection = New OleDbConnection(str)
conn.Open()
Dim str1 As String = "INSERT INTO family_v2(名字(Name))VALUES('jack')"
Dim cmd As OleDbCommand = New OleDbCommand(str1, conn)
cmd.ExecuteNonQuery()
conn.Close()
I want to put "jack" into datasheet "family_v2" in field "名字(Name)"....
The error is :
cmd.ExecuteNonQuery() >>>INSERT INTO 陳述式的語法錯誤。
But I have checked it....it is correct....can anyone help?
Dim conn As OleDbConnection = New OleDbConnection(str)
conn.Open()
Dim str1 As String = "INSERT INTO family_v2(名字(Name))VALUES('jack')"
Dim cmd As OleDbCommand = New OleDbCommand(str1, conn)
cmd.ExecuteNonQuery()
conn.Close()
I want to put "jack" into datasheet "family_v2" in field "名字(Name)"....
The error is :
cmd.ExecuteNonQuery() >>>INSERT INTO 陳述式的語法錯誤。
But I have checked it....it is correct....can anyone help?