Работа с базами данных на C#. Урок 3. Сохранение данных.

        private void button1_Click(object sender, EventArgs e)

        {

            waresTableAdapter.Update(myBaseDataSet);

        }

   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);

        }