Update i Acces
får denne fejl:Operation must use an updateable query.
her er min update funk:
public void UpdatePrice(Object Sender,EventArgs e)
{
OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=c:\\Program Files\\Microsoft Office\\Office\\Samples\\Nwind.mdb;" +
"User ID=;Password=;");
con.Open();
//Build update command
//string sqlQ = "Update Products Set UnitPrice = " + Price.Text + " where ProductName = '" + Name.Text + "'";
string sqlQ1 = "Update Products Set UnitPrice = 22 where ProductName = 'Chang'";
OleDbCommand cmd = new OleDbCommand(sqlQ1, con);
int nRowsAffected = 0;
nRowsAffected = cmd.ExecuteNonQuery();
Status.Text = "<hr />" + nRowsAffected.ToString() + "rows has been changed";
}
}
Det kan da ikke være helt forkert :-)
