CSharp oleDB - INSERT INTO
-
Hi, i've got a problem when i tried to INSERT details to OLEDB Access. this is my code: <pre> public class registrationClass { static string connStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\WebSites\DB\users.mdb;Persist Security Info=True"; public static string details(string username, string pass, string email) { string input; //bool Enter = true; OleDbConnection conn = new OleDbConnection(connStr); conn.Open(); input = String.Format(@"INSERT INTO userAuth (user,password,Email) VALUES ('{0}','{1}','{2}')", username, pass, email); OleDbCommand cmd = new OleDbCommand(input, conn); cmd.ExecuteNonQuery(); conn.Close(); return String.Format("Done"); } </pre> now, when i searched on the web, i saw that my query is well. when i did debug to this action, the input looks like: "INSERT INTO userAuth (user,password,Email) VALUES ('Igor','pass123','igor@email.com')" whats wrong???????? thank u!!!
-
Hi, i've got a problem when i tried to INSERT details to OLEDB Access. this is my code: <pre> public class registrationClass { static string connStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\WebSites\DB\users.mdb;Persist Security Info=True"; public static string details(string username, string pass, string email) { string input; //bool Enter = true; OleDbConnection conn = new OleDbConnection(connStr); conn.Open(); input = String.Format(@"INSERT INTO userAuth (user,password,Email) VALUES ('{0}','{1}','{2}')", username, pass, email); OleDbCommand cmd = new OleDbCommand(input, conn); cmd.ExecuteNonQuery(); conn.Close(); return String.Format("Done"); } </pre> now, when i searched on the web, i saw that my query is well. when i did debug to this action, the input looks like: "INSERT INTO userAuth (user,password,Email) VALUES ('Igor','pass123','igor@email.com')" whats wrong???????? thank u!!!
Ido Shahar wrote:
i've got a problem
Do you? which problem? what are the symptoms? does it compile? does it run? does it throw an exception? which exception? at what line? does your SQL statement work for you when entered in Access itself? :)
Luc Pattyn [Forum Guidelines] [My Articles]
Avoiding unwanted divs (as in "articles needing approval") with the help of this FireFox add-in
-
Ido Shahar wrote:
i've got a problem
Do you? which problem? what are the symptoms? does it compile? does it run? does it throw an exception? which exception? at what line? does your SQL statement work for you when entered in Access itself? :)
Luc Pattyn [Forum Guidelines] [My Articles]
Avoiding unwanted divs (as in "articles needing approval") with the help of this FireFox add-in
-
Ido Shahar wrote:
i've got a problem
Do you? which problem? what are the symptoms? does it compile? does it run? does it throw an exception? which exception? at what line? does your SQL statement work for you when entered in Access itself? :)
Luc Pattyn [Forum Guidelines] [My Articles]
Avoiding unwanted divs (as in "articles needing approval") with the help of this FireFox add-in
-
You right, i didnt write any descriptions of symptoms. i've got an Exception about "Syntax error in INSERT INTO statement" in Line "cmd.ExecuteNonQuery();" 10x
When you enter the exact error message ("Syntax error in INSERT INTO statement") in Google, the first hit explains what is wrong. So learn to Google, it often solves your problem in a matter of seconds. :)
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get. Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
-
When you enter the exact error message ("Syntax error in INSERT INTO statement") in Google, the first hit explains what is wrong. So learn to Google, it often solves your problem in a matter of seconds. :)
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get. Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
-
wtf! it wasnt necessary to say what u said. i have googled it, and also tried to changed password to [password] but also, i've got an exception! bye
-
wtf! it wasnt necessary to say what u said. i have googled it, and also tried to changed password to [password] but also, i've got an exception! bye
is it a PebkacException? :)
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get. Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
-
is it a PebkacException? :)
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get. Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
ok, I got it!!!! the problem was the column names and the way of writing. the fixed is: <code> input = @"INSERT INTO userAuth ([user], [pass], [mail]) VALUES ('" + username + "', '" + pass + "', '" + email + "') "; </code> and the parameters that i sending is after casting ToString(), also, in the DB i changed the Column rule to string and not email column as i defined before. thanks to everyone. ido.