My name is vatsal from baroda, gujarat,india.
I have problem in ASP.Net , when i insert record in MSAccess through ASP.net , it display an error : you must use updateable query
I have pentiumIV pc & loading operating system is XP professional
code is :
private void insert_click()
{
oledbconnection connection=(“provider=”);
oledbCommand cmd= new oledbCommand(“insert into tcategory(cid,cname) values(@cid,@cname)”,connection);
cmd.parameters.add(“@cid”,textbox1.text);
cmd.parameters.add(“@cname”,textbox2.text);
connection.open();
cmd.executeNonQuery);
connection.close();
}
This coding is right or wrong please inform me.
if you know the solution please send the solution