Problem in accessing MSAccess

[raghulvarma]

I am not able to insert values into msacess what could be the error in the below shown statement?

 
string con = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("Database2.mdb");
       using (OleDbConnection connection = new OleDbConnection(con))
       {
           using (OleDbCommand cmd = new OleDbCommand("insert into Connpool (bookid,bookname,amt) values (?,?,?)", connection))
           {
               cmd.CommandType = CommandType.Text;
               cmd.Parameters.AddWithValue("bookid", TextBox1.Text);
               cmd.Parameters.AddWithValue("bookname", TextBox2.Text);
               cmd.Parameters.AddWithValue("amt", TextBox3.Text);
               connection.Open();
               cmd.ExecuteNonQuery();
               connection.Close();
 
           }
 
       }
 

[r035198x]

What happens whne you run that code? Do you get an error message?

[raghulvarma]

Thax a lot sir it works well now

[r035198x]

Thax a lot sir it works well now

Credit should be given to you for getting it to work not me. I didn't do anything.