dataset.Update impossible!

  • Thread starter Thread starter wavemill
  • Start date Start date
W

wavemill

I have this error, i don't know why!
Une exception non gérée du type 'System.InvalidOperationException'
s'est

produite dans System.Data.Common.dll

Informations supplémentaires : Dynamic SQL generation for the

UpdateCommand is not supported against a SelectCommand that does not

return any key column information.

My code:
string test = "Data Source =\\My Documents\\north.sdf" + ";Password=";
SqlCeConnection cn = new SqlCeConnection(test);
cn.Open();
DataSet ds2 = new DataSet();
SqlCeDataAdapter da = new SqlCeDataAdapter("SELECT * FROM Products
WHERE

ProductID='" + productID + "'",cn);
da.MissingSchemaAction = MissingSchemaAction.AddWithKey;
SqlCeCommandBuilder cb2 = new SqlCeCommandBuilder(da);
da.Fill(ds2,"Products");
ds2.Tables["Products"].PrimaryKey = new DataColumn[]{

ds2.Tables["Products"].Columns["ProductID"]};


DataRow dr = ds2.Tables["Products"].Rows[0];
dr["UnitsInStock"] = actualNumericUpDown.Value;

da.Update(ds2,"Products");
ds2.AcceptChanges();
cn.Close();

Thank you

Wavemill
 
Back
Top