ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
this error is giving me while hosting site...but onlocal host it is working properly ..
please help me ..
thanks in Advance ...
my code is
protected void btnsignup_Click(object sender, EventArgs e)
{
if (txtuname.Text != string.Empty && txtmailid.Text != string.Empty && txtmobile.Text != string.Empty && txtpwd.Text != string.Empty)
{
con.Open();
OdbcCommand cmd = new OdbcCommand("Insert into LOGIN (U_name,U_Email,U_Mobile,U_password) values(?,?,?,?)", con);
cmd.Parameters.AddWithValue("username", txtuname.Text);
cmd.Parameters.AddWithValue("useremail", txtmailid.Text);
cmd.Parameters.AddWithValue("usermobile", txtmobile.Text);
cmd.Parameters.AddWithValue("userpassword", txtpwd.Text);
cmd.ExecuteNonQuery();
con.Close();
clear();
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertmessage", "javascript:alert('Sign up successfully , please enter your username and password ,have a nice time ')", true);
Panel2.Visible = false;
Panel1.Visible = true;
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertmessage", "javascript:alert('Fields cannot be left blank ')", true);
}
}