我用的是asp.net和access数据库
代码: Dim conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=D:\renshichu_db.mdb;")
Dim cmd As OleDbCommand
conn.Open()
Dim insertcmd As String = "Insert Into login (name,password) values(@name,@word)" cmd = New OleDbCommand(insertcmd, conn)
'添加登陆名
cmd.Parameters.Add(New OleDbParameter("@name", OleDbType.VarChar, 20))
cmd.Parameters("@name").Value = user_name
'添加密码
cmd.Parameters.Add(New OleDbParameter("@word", OleDbType.VarChar, 20))
cmd.Parameters("@word").Value = pass_word
运行结果说insert into 有语法错误
代码: Dim conn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=D:\renshichu_db.mdb;")
Dim cmd As OleDbCommand
conn.Open()
Dim insertcmd As String = "Insert Into login (name,password) values(@name,@word)" cmd = New OleDbCommand(insertcmd, conn)
'添加登陆名
cmd.Parameters.Add(New OleDbParameter("@name", OleDbType.VarChar, 20))
cmd.Parameters("@name").Value = user_name
'添加密码
cmd.Parameters.Add(New OleDbParameter("@word", OleDbType.VarChar, 20))
cmd.Parameters("@word").Value = pass_word
运行结果说insert into 有语法错误
Insert Into login ([name],[password]) values(@name,@word)
inert into login values(@name,@word)
中间不要加空格。