hello friends ,
here i completed my windows application , and i did setup .exe file that i installed and checks the application , but while inserting a values getting an error {Operation must use an updateable query}database is Ms access 2007 , using WPF .
this code works fine in visual studio while executing but after making an setup .exe and installation of this application getting error while inserting a values.
please help me out of this ,from past 10 days i was searching in online and rectifying this error .
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|/database/phonebook.accdb;Persist Security Info=True;Jet OLEDB:Database Password=mr.vj;");
conn.Open();
cmdd.CommandText = "INSERT into logindetails([lusername],[login]) VALUES(@luname,@last)";
cmdd.Parameters.Clear();
cmdd.Parameters.AddWithValue("@luname", textBoxname.Text);
cmdd.Parameters.AddWithValue("@last", llin);
cmdd.ExecuteNonQuery();
conn.Close();
thanking you in advance .