ASP.net always said somethings wrong with the insert into statement
but I can't figure it out...........
The error is : some things wrong with the INSERT INTO CLAUSE
any one can help me
Database strucutre:
http://xs.to/xs.php?h=xs23&d=05143&f=structure.JPG
Code:
dim conn as new oledbconnection(application("connectstring"))
conn.open()
dim userinsert as string="INSERT INTO user (login_id, [password], name, email, address1, address2, address3, home, office, question, answer) VALUES (@login_id, @password, @name, @email, @address1, @address2, @address3, @home, @office, @question, @answer)"
dim cmd as new oledbcommand(userinsert,conn)
cmd.parameters.add(new oledbparameter("@Login_id",oledbtype.char,19))
cmd.parameters(0).value=txtid.text
cmd.parameters.add(new oledbparameter("@password",oledbtype.char,20))
cmd.parameters(1).value=txtpass1.text
cmd.parameters.add(new oledbparameter("@name",oledbtype.char,50))
cmd.parameters(2).value=txtfull.text
cmd.parameters.add(new oledbparameter("@email",oledbtype.char,30))
cmd.parameters(3).value=txtemail.text
cmd.parameters.add(new oledbparameter("@address1",oledbtype.char,20))
cmd.parameters(4).value=txtadd1.text
cmd.parameters.add(new oledbparameter("@address2",oledbtype.char,20))
cmd.parameters(5).value=txtadd2.text
cmd.parameters.add(new oledbparameter("@address3",oledbtype.char,10))
cmd.parameters(6).value=txtadd3.text
cmd.parameters.add(new oledbparameter("@home",oledbtype.char,16))
cmd.parameters(7).value=txthome.text
cmd.parameters.add(new oledbparameter("@office",oledbtype.char,16))
cmd.parameters(8).value=txtoffice.text
cmd.parameters.add(new oledbparameter("@question",oledbtype.char,50))
cmd.parameters(9).value="home tel"
cmd.parameters.add(new oledbparameter("@answer",oledbtype.char,50))
cmd.parameters(10).value="26940671"
cmd.executenonquery()
conn.dispose()
oledbcommand insert help
