private void
button1_Click(object sender,
EventArgs e)
{
SqlCeCommand command =
new SqlCeCommand(
"UPDATE wares SET ID = @ID, Name
= @Name, Price=@Price "+
"WHERE (ID = @ID)");
command.Connection = waresTableAdapter.Connection;
waresTableAdapter.Adapter.UpdateCommand = command;
SqlCeParameter parametr;
//
ID
parametr = new
SqlCeParameter("@ID",
SqlDbType.Int);
parametr.SourceColumn = "ID";
command.Parameters.Add(parametr);
//
Name
parametr = new
SqlCeParameter("@Name",
DbType.String);
parametr.SourceColumn = "Name";
command.Parameters.Add(parametr);
//
Price
parametr = new
SqlCeParameter("@Price",
SqlDbType.Float);
parametr.SourceColumn = "Price";
command.Parameters.Add(parametr);
waresTableAdapter.Update(myBaseDataSet.Wares);
} |