error "cannot open the action query"

[sarabonn]

hallo

Iam trying to insert a row into a access database using visual c# and iam getting an error " cannot open the action query". here is my code

 
private void button1_Click(object sender, EventArgs e)
        {
     txt1 = textBox1.Text;
            txt2 = textBox2.Text;
            String connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Userinfo.accdb";
            OleDbConnection connection = new OleDbConnection(connectionString);
                       OleDbCommand command = new OleDbCommand();           
 
 
              command.CommandType = CommandType.TableDirect;
              command.CommandText = "INSERT INTO userinfo (Username, Pwd) VALUES (‘" + txt1 + "’ , ‘" + txt2 + "’)";
              command.Connection = connection;
              connection.Open();
              command.ExecuteNonQuery(); // getting in this line .
              connection.Close();
 
 

any idea why is this error ?

Thank you.
Dinesh.

[Curtis Rutland]

Please enclose your posted code in [CODE] [/CODE] tags (See How to Ask a Question).

This makes it easier for our Experts to read and understand it. Failing to do so creates extra work for the moderators, thus wasting resources, otherwise available to answer the members' questions.

Please use [CODE] [/CODE] tags in future.

MODERATOR

[Plater]

Your CommandType should be
CommandType.Tex t

With TableDirect, I believe you would just make CommandText ="MyTableNam e" and it would return the contents of the entire table

[sarabonn]

Your CommandType should be
CommandType.Tex t

With TableDirect, I believe you would just make CommandText ="MyTableNam e" and it would return the contents of the entire table

hallo plater,

If i use the CommanType.Text it gives me error "No value given for one or more required parameters." in the line Command.Execute NonQuery();.

Thank you.

Dinesh.

[MrMancunian]

Instead of

command.CommandText = "INSERT INTO userinfo (Username, Pwd) VALUES (‘" + txt1 + "’ , ‘" + txt2 + "’)";
 

use

command.InsertCommand = "INSERT INTO userinfo (Username, Pwd) VALUES (‘" + txt1 + "’ , ‘" + txt2 + "’)"; 
 

Steven

[sarabonn]

Instead of

command.CommandText = "INSERT INTO userinfo (Username, Pwd) VALUES (‘" + txt1 + "’ , ‘" + txt2 + "’)";
 

use

command.InsertCommand = "INSERT INTO userinfo (Username, Pwd) VALUES (‘" + txt1 + "’ , ‘" + txt2 + "’)"; 
 

Steven

hallo steven,

Command is an object oldbcommand and it doesn't have the command.insertc ommand or do you mean oledbdataadapte r.InsertCommand ?..

thank you,

dinesh.

[MrMancunian]

hallo steven,

Command is an object oldbcommand and it doesn't have the command.insertc ommand or do you mean oledbdataadapte r.InsertCommand ?..

thank you,

dinesh.

Yes, sorry, I meant the DataAdapter.Ins ertCommand

Steven

[sarabonn]

Yes, sorry, I meant the DataAdapter.Ins ertCommand

Steven

hallo steven,

I changed the code like this with the dataadapter.ins ertcommand but iam getting a error "No value given for one or more required parameters." in the executenonquery () line. Iam sure about the table details.

private void button1_Click(object sender, EventArgs e)
        {
         txt1 = textBox1.Text;
            txt2 = textBox2.Text;
            txt3 = textBox1.Text;
             txt4 = textBox2.Text;
            OleDbConnection cnJetDB = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Userinfo.accdb");
            cnJetDB.Open();
            OleDbDataAdapter oleDa = new OleDbDataAdapter();
            OleDbCommand cmdInsert = new OleDbCommand("INSERT INTO userinfo (Username, Pwd,Openid,ServerUrl)" + "VALUES (" + txt1 + "," + txt2 + "," + txt3 + "," + txt4 + ")", cnJetDB);
 
            oleDa.InsertCommand = cmdInsert;
 
            cmdInsert.ExecuteNonQuery();
            cnJetDB.Close();
} 
 

any idea steven ?..

Thank you.
Dinesh

[Plater]

I would say your problem is using the illegal quote character in your string. try using the regular ' single quote and see if that works for you.

[r035198x]

I would say your problem is using the illegal quote character in your string. try using the regular ' single quote and see if that works for you.

I don't see any quotes around the text values there at all legal or otherwise. My colleagues say that I'm getting old so my eyes may be the problem.