Can someone please help me on this problem. I am trying to send the updated changes to the sql database when I remove a row. I use the delete method to delete the numbered row through a dataview and then use the upate command to update the changes to the sql database. However, when I reload the program the rows are still there. Below is the current code I am using. This has been racking my brain for awhile now and any further help would be appreciated.

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.Common;
using System.Data.SqlClient;

namespace MovieDiary
{
    /// <summary>
    /// Summary description for Form1.
    /// </summary>
    public class Form1 : System.Windows.Forms.Form
    {
        public System.Windows.Forms.DataGrid dataGrid1;
        /// <summary>
        /// Required designer variable.
        /// </summary>
        public System.ComponentModel.Container components = null;

        public static SqlConnection Mcon = new SqlConnection("Server=Homer;Database = Mov_Dbase;Integrated Security=SSPI; data source=\"Ho" +
            "mer\\SQLEXPRESS\"");
        //Capture the clicked cell
        private DataGrid.HitTestInfo hitTestGrid;
        public static SqlDataAdapter MovAdapt = new SqlDataAdapter(" SELECT * FROM MovTable1", Mcon);
        SqlCommandBuilder cb = new SqlCommandBuilder(MovAdapt);
        DataTableMapping myNewMapping =
            new DataTableMapping("MovMap", "MovTable1");
        private System.Windows.Forms.Label label1;
        private System.Windows.Forms.Button button2;

        private System.Windows.Forms.Label label2;
        private System.Windows.Forms.Button button4;
        private System.Windows.Forms.Button button5;
        private System.Windows.Forms.Button button6;
        private System.Windows.Forms.Button button7;
        private System.Windows.Forms.Button button8;
        private System.Windows.Forms.Button button9;
        private System.Windows.Forms.Button button10;
        private System.Windows.Forms.Label label3;
        private System.Windows.Forms.TextBox textBox1;
        private System.Windows.Forms.Label label4;
        DataGridTextBoxColumn dataGridComboBox = new DataGridTextBoxColumn();
        DataGridTextBoxColumn dataGridComboBox2 = new DataGridTextBoxColumn();
        DataView Dv = new DataView();

        public static DataSet Movset1 = new DataSet("Movie List");

        Form2 frm2 = new Form2();





        //Define controls must be add to data grid.     
        private ComboBox cboControl = new ComboBox();
        private ComboBox cboControl2 = new ComboBox();

        //Control definishion to add to DataGrid
        DataGridTableStyle dataGridStyle = new DataGridTableStyle();

        //Create the TextBox columns for the datagrid columns
        DataGridTextBoxColumn aCol1 = new DataGridTextBoxColumn();
        DataGridTextBoxColumn aCol2 = new DataGridTextBoxColumn();
        DataGridTextBoxColumn aCol3 = new DataGridTextBoxColumn();
        DataGridTextBoxColumn aCol4 = new DataGridTextBoxColumn();
        //DataGridTextBoxColumn aCol6 = new DataGridTextBoxColumn();
        DataGridBoolColumn aCol6 = new DataGridBoolColumn();

        DataGridTextBoxColumn aCol5 = new DataGridTextBoxColumn();
        CheckBox chk1 = new CheckBox();
        public MessageBox MesBox;


        public string Movstring;
        public int CurRow = -1;
        public int CurCol = -1;
        public string CellValue;
        public bool strValue = false;
        private System.Windows.Forms.Button button11;
        private System.Windows.Forms.Button button12;
        private System.Windows.Forms.Button Findbtn;
        public System.Windows.Forms.Button UpdateSavebtn;
        public bool imageswitch;
        string Combostr;
        public int GblChkval = 0;
        public int ChkValTr = 0;
        public int ChkVAlFr = 0;
        public int StartValue = 1;
        private Button button1;
        private GroupBox groupBox1;
        public int ChkVal = 1;
        private Button button3;
        public static int UpdateVal = 0;



        public void Imagescrn()
        {
            this.BackgroundImage = Image.FromFile("C:\\Documents and Settings\\Mark\\My Documents\\My Pictures\\house_pg2.jpg");
        }
        public void ImageMain()
        {
            // this.BackgroundImage = Image.FromFile("C:\\Documents and Settings\\Mark\\My Documents\\My Pictures\\bg_page.jpg");
        }


        public Form1()
        {
            //
            // Required for Windows Form Designer support
            //
            InitializeComponent();
            //Add combobox control to datagrid.
            dataGridComboBox.TextBox.Controls.Add(cboControl);
            cboControl.Items.AddRange(new string[8] { "", "Horror", "Action/Thriller", "TV/Series", "Sci-fi/Fantasy", "Family", "Drama", "Comedy" });

            dataGridComboBox2.TextBox.Controls.Add(cboControl2);
            cboControl2.Items.AddRange(new string[3] { "", "DVD", "Blue-Ray" });

            //
            // TODO: Add any constructor code after InitializeComponent call
            //
        }

        /// <summary>
        /// Clean up any resources being used.
        /// </summary>
        protected override void Dispose(bool disposing)
        {
            if (disposing)
            {
                if (components != null)
                {
                    components.Dispose();
                }
            }
            base.Dispose(disposing);
        }

        #region Windows Form Designer generated code
        /// <summary>
        /// Required method for Designer support - do not modify
        /// the contents of this method with the code editor.
        /// </summary>
        private void InitializeComponent()
        {
            System.Configuration.AppSettingsReader configurationAppSettings = new System.Configuration.AppSettingsReader();
            this.dataGrid1 = new System.Windows.Forms.DataGrid();
            this.UpdateSavebtn = new System.Windows.Forms.Button();
            this.label1 = new System.Windows.Forms.Label();
            this.button2 = new System.Windows.Forms.Button();
            this.label2 = new System.Windows.Forms.Label();
            this.button4 = new System.Windows.Forms.Button();
            this.button5 = new System.Windows.Forms.Button();
            this.button6 = new System.Windows.Forms.Button();
            this.button7 = new System.Windows.Forms.Button();
            this.button8 = new System.Windows.Forms.Button();
            this.button9 = new System.Windows.Forms.Button();
            this.button10 = new System.Windows.Forms.Button();
            this.label3 = new System.Windows.Forms.Label();
            this.textBox1 = new System.Windows.Forms.TextBox();
            this.label4 = new System.Windows.Forms.Label();
            this.Findbtn = new System.Windows.Forms.Button();
            this.button11 = new System.Windows.Forms.Button();
            this.button12 = new System.Windows.Forms.Button();
            this.button1 = new System.Windows.Forms.Button();
            this.button3 = new System.Windows.Forms.Button();
            ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
            this.SuspendLayout();
            // 
            // dataGrid1
            // 
            this.dataGrid1.AccessibleDescription = "public";
            this.dataGrid1.AllowDrop = true;
            this.dataGrid1.ColumnHeadersVisible = ((bool)(configurationAppSettings.GetValue("dataGrid1.ColumnHeadersVisible", typeof(bool))));
            this.dataGrid1.DataMember = ((string)(configurationAppSettings.GetValue("dataGrid1.DataMember", typeof(string))));
            this.dataGrid1.ForeColor = System.Drawing.SystemColors.ActiveCaption;
            this.dataGrid1.HeaderBackColor = System.Drawing.Color.WhiteSmoke;
            this.dataGrid1.HeaderForeColor = System.Drawing.Color.Black;
            this.dataGrid1.Location = new System.Drawing.Point(152, 128);
            this.dataGrid1.Name = "dataGrid1";
            this.dataGrid1.ReadOnly = ((bool)(configurationAppSettings.GetValue("dataGrid1.ReadOnly", typeof(bool))));
            this.dataGrid1.RowHeaderWidth = 0;
            this.dataGrid1.SelectionBackColor = System.Drawing.SystemColors.Info;
            this.dataGrid1.Size = new System.Drawing.Size(575, 232);
            this.dataGrid1.TabIndex = 0;
            this.dataGrid1.MouseUp += new System.Windows.Forms.MouseEventHandler(this.dataGrid1_MouseUp);
            this.dataGrid1.CurrentCellChanged += new System.EventHandler(this.dataGrid1_CurrentCellChanged);
            // 
            // UpdateSavebtn
            // 
            this.UpdateSavebtn.BackColor = System.Drawing.Color.Silver;
            this.UpdateSavebtn.Location = new System.Drawing.Point(312, 376);
            this.UpdateSavebtn.Name = "UpdateSavebtn";
            this.UpdateSavebtn.Size = new System.Drawing.Size(128, 32);
            this.UpdateSavebtn.TabIndex = 1;
            this.UpdateSavebtn.Text = "Update And Save";
            this.UpdateSavebtn.UseVisualStyleBackColor = false;
            this.UpdateSavebtn.Click += new System.EventHandler(this.UpdateSavebtn_Click_1);
            // 
            // label1
            // 
            this.label1.Font = new System.Drawing.Font("Microsoft Sans Serif", 20F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
            this.label1.Location = new System.Drawing.Point(264, 16);
            this.label1.Name = "label1";
            this.label1.Size = new System.Drawing.Size(208, 40);
            this.label1.TabIndex = 2;
            this.label1.Text = "MovieBase";
            this.label1.Click += new System.EventHandler(this.label1_Click);
            // 
            // button2
            // 
            this.button2.BackColor = System.Drawing.Color.Silver;
            this.button2.ForeColor = System.Drawing.Color.ForestGreen;
            this.button2.Location = new System.Drawing.Point(715, 381);
            this.button2.Name = "button2";
            this.button2.Size = new System.Drawing.Size(64, 32);
            this.button2.TabIndex = 4;
            this.button2.Text = "Exit";
            this.button2.UseVisualStyleBackColor = false;
            this.button2.Click += new System.EventHandler(this.button2_Click);
            // 
            // label2
            // 
            this.label2.BackColor = System.Drawing.Color.Silver;
            this.label2.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
            this.label2.ForeColor = System.Drawing.Color.Red;
            this.label2.Location = new System.Drawing.Point(8, 128);
            this.label2.Name = "label2";
            this.label2.Size = new System.Drawing.Size(136, 24);
            this.label2.TabIndex = 7;
            this.label2.Text = "List By Category";
            this.label2.Click += new System.EventHandler(this.label2_Click);
            // 
            // button4
            // 
            this.button4.BackColor = System.Drawing.Color.Silver;
            this.button4.FlatStyle = System.Windows.Forms.FlatStyle.Popup;
            this.button4.Font = new System.Drawing.Font("Blackadder ITC", 14.25F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))), System.Drawing.GraphicsUnit.Point, ((byte)(0)));
            this.button4.ForeColor = System.Drawing.Color.DarkBlue;
            this.button4.Location = new System.Drawing.Point(8, 152);
            this.button4.Name = "button4";
            this.button4.Size = new System.Drawing.Size(136, 32);
            this.button4.TabIndex = 8;
            this.button4.Text = "Horror";
            this.button4.UseVisualStyleBackColor = false;
            this.button4.Click += new System.EventHandler(this.button4_Click);
            // 
            // button5
            // 
            this.button5.BackColor = System.Drawing.Color.Silver;
            this.button5.FlatStyle = System.Windows.Forms.FlatStyle.Popup;
            this.button5.Font = new System.Drawing.Font("Rockwell", 8.3F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))), System.Drawing.GraphicsUnit.Point, ((byte)(0)));
            this.button5.ForeColor = System.Drawing.Color.DarkBlue;
            this.button5.Location = new System.Drawing.Point(8, 280);
            this.button5.Name = "button5";
            this.button5.Size = new System.Drawing.Size(136, 32);
            this.button5.TabIndex = 9;
            this.button5.Text = "Family/Entertainment";
            this.button5.UseVisualStyleBackColor = false;
            this.button5.Click += new System.EventHandler(this.button5_Click);
            // 
            // button6
            // 
            this.button6.BackColor = System.Drawing.Color.Silver;
            this.button6.FlatStyle = System.Windows.Forms.FlatStyle.Popup;
            this.button6.Font = new System.Drawing.Font("Microsoft Sans Serif", 9F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))), System.Drawing.GraphicsUnit.Point, ((byte)(0)));
            this.button6.ForeColor = System.Drawing.Color.DarkBlue;
            this.button6.Location = new System.Drawing.Point(8, 184);
            this.button6.Name = "button6";
            this.button6.Size = new System.Drawing.Size(136, 32);
            this.button6.TabIndex = 10;
            this.button6.Text = "Action/Thriller";
            this.button6.UseVisualStyleBackColor = false;
            this.button6.Click += new System.EventHandler(this.button6_Click);
            // 
            // button7
            // 
            this.button7.BackColor = System.Drawing.Color.Silver;
            this.button7.FlatStyle = System.Windows.Forms.FlatStyle.Popup;
            this.button7.Font = new System.Drawing.Font("Impact", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
            this.button7.ForeColor = System.Drawing.Color.DarkBlue;
            this.button7.Location = new System.Drawing.Point(8, 248);
            this.button7.Name = "button7";
            this.button7.Size = new System.Drawing.Size(136, 32);
            this.button7.TabIndex = 11;
            this.button7.Text = "Sci-Fi/Fantasy";
            this.button7.UseVisualStyleBackColor = false;
            this.button7.Click += new System.EventHandler(this.button7_Click);
            // 
            // button8
            // 
            this.button8.BackColor = System.Drawing.Color.Silver;
            this.button8.FlatStyle = System.Windows.Forms.FlatStyle.Popup;
            this.button8.Font = new System.Drawing.Font("Perpetua", 14F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
            this.button8.ForeColor = System.Drawing.Color.DarkBlue;
            this.button8.Location = new System.Drawing.Point(8, 312);
            this.button8.Name = "button8";
            this.button8.Size = new System.Drawing.Size(136, 32);
            this.button8.TabIndex = 12;
            this.button8.Text = "Drama";
            this.button8.UseVisualStyleBackColor = false;
            this.button8.Click += new System.EventHandler(this.button8_Click);
            // 
            // button9
            // 
            this.button9.BackColor = System.Drawing.Color.Silver;
            this.button9.FlatStyle = System.Windows.Forms.FlatStyle.Popup;
            this.button9.Font = new System.Drawing.Font("Perpetua", 14F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
            this.button9.ForeColor = System.Drawing.Color.DarkBlue;
            this.button9.Location = new System.Drawing.Point(8, 216);
            this.button9.Name = "button9";
            this.button9.Size = new System.Drawing.Size(136, 32);
            this.button9.TabIndex = 13;
            this.button9.Text = "TV/Series";
            this.button9.UseVisualStyleBackColor = false;
            this.button9.Click += new System.EventHandler(this.button9_Click);
            // 
            // button10
            // 
            this.button10.BackColor = System.Drawing.Color.Silver;
            this.button10.Location = new System.Drawing.Point(176, 376);
            this.button10.Name = "button10";
            this.button10.Size = new System.Drawing.Size(120, 32);
            this.button10.TabIndex = 14;
            this.button10.Text = "Back To Main List";
            this.button10.UseVisualStyleBackColor = false;
            this.button10.Click += new System.EventHandler(this.button10_Click);
            // 
            // label3
            // 
            this.label3.BackColor = System.Drawing.Color.Silver;
            this.label3.Location = new System.Drawing.Point(8, 40);
            this.label3.Name = "label3";
            this.label3.Size = new System.Drawing.Size(104, 23);
            this.label3.TabIndex = 15;
            this.label3.Text = "Search Movie";
            // 
            // textBox1
            // 
            this.textBox1.Location = new System.Drawing.Point(8, 64);
            this.textBox1.Name = "textBox1";
            this.textBox1.Size = new System.Drawing.Size(100, 20);
            this.textBox1.TabIndex = 16;
            this.textBox1.TextChanged += new System.EventHandler(this.textBox1_TextChanged);
            // 
            // label4
            // 
            this.label4.BackColor = System.Drawing.Color.Silver;
            this.label4.Location = new System.Drawing.Point(8, 88);
            this.label4.Name = "label4";
            this.label4.Size = new System.Drawing.Size(104, 16);
            this.label4.TabIndex = 17;
            this.label4.Text = "Enter Title";
            // 
            // Findbtn
            // 
            this.Findbtn.BackColor = System.Drawing.Color.Silver;
            this.Findbtn.Location = new System.Drawing.Point(112, 64);
            this.Findbtn.Name = "Findbtn";
            this.Findbtn.Size = new System.Drawing.Size(56, 24);
            this.Findbtn.TabIndex = 18;
            this.Findbtn.Text = "Find";
            this.Findbtn.UseVisualStyleBackColor = false;
            this.Findbtn.Click += new System.EventHandler(this.Findbtn_Click);
            // 
            // button11
            // 
            this.button11.BackColor = System.Drawing.Color.Silver;
            this.button11.FlatStyle = System.Windows.Forms.FlatStyle.Popup;
            this.button11.Font = new System.Drawing.Font("Papyrus", 10.5F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
            this.button11.ForeColor = System.Drawing.Color.DarkBlue;
            this.button11.Location = new System.Drawing.Point(8, 344);
            this.button11.Name = "button11";
            this.button11.Size = new System.Drawing.Size(136, 32);
            this.button11.TabIndex = 19;
            this.button11.Text = "Comedy";
            this.button11.UseVisualStyleBackColor = false;
            // 
            // button12
            // 
            this.button12.Location = new System.Drawing.Point(152, 104);
            this.button12.Name = "button12";
            this.button12.Size = new System.Drawing.Size(80, 23);
            this.button12.TabIndex = 20;
            this.button12.Text = "Display List";
            this.button12.Click += new System.EventHandler(this.button12_Click);
            // 
            // button1
            // 
            this.button1.Location = new System.Drawing.Point(731, 12);
            this.button1.Name = "button1";
            this.button1.Size = new System.Drawing.Size(48, 23);
            this.button1.TabIndex = 21;
            this.button1.Text = "Help";
            this.button1.UseVisualStyleBackColor = true;
            // 
            // button3
            // 
            this.button3.Location = new System.Drawing.Point(460, 376);
            this.button3.Name = "button3";
            this.button3.Size = new System.Drawing.Size(75, 32);
            this.button3.TabIndex = 22;
            this.button3.Text = "Delete  Movie";
            this.button3.UseVisualStyleBackColor = true;
            this.button3.Click += new System.EventHandler(this.button3_Click_1);
            // 
            // Form1
            // 
            this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
            this.BackColor = System.Drawing.Color.DarkRed;
            this.ClientSize = new System.Drawing.Size(791, 446);
            this.Controls.Add(this.button3);
            this.Controls.Add(this.button1);
            this.Controls.Add(this.button12);
            this.Controls.Add(this.button11);
            this.Controls.Add(this.Findbtn);
            this.Controls.Add(this.label4);
            this.Controls.Add(this.textBox1);
            this.Controls.Add(this.label3);
            this.Controls.Add(this.button10);
            this.Controls.Add(this.button9);
            this.Controls.Add(this.button8);
            this.Controls.Add(this.button7);
            this.Controls.Add(this.button6);
            this.Controls.Add(this.button5);
            this.Controls.Add(this.button4);
            this.Controls.Add(this.label2);
            this.Controls.Add(this.button2);
            this.Controls.Add(this.label1);
            this.Controls.Add(this.UpdateSavebtn);
            this.Controls.Add(this.dataGrid1);
            this.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.3F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
            this.KeyPreview = true;
            this.Name = "Form1";
            this.Text = "Form1";
            this.Load += new System.EventHandler(this.Form1_Load);
            this.Enter += new System.EventHandler(this.Form1_Enter);
            ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
            this.ResumeLayout(false);
            this.PerformLayout();

        }
        #endregion

        /// <summary>
        /// The main entry point for the application.
        /// </summary>
        [STAThread]
        static void Main()
        {
            Application.Run(new Form1());
        }




        public void Form1_Load(object sender, System.EventArgs e)
        {
            //Add a new table style to datagrid.
            DesignTableStyle();
            dataGrid1.RowHeadersVisible = true;
            dataGrid1.DataSource = Movset1;
            MovAdapt.Fill(Movset1, "MovTable1");
            dataGrid1.DataSource = Movset1;



            aCol6.AllowNull = false;
            label1.Show();

            Show();
            dataGrid1.Show();




        }

        //Add a new table style to datagrid.
        private void DesignTableStyle()
        {
            dataGridStyle.PreferredRowHeight = 24;
            dataGridStyle.MappingName = "MovTable1";

            //
            // Create GridColumnStyle objects for the grid columns
            //          

            aCol1.HeaderText = "Item No";
            aCol1.MappingName = "Number";
            aCol2.Width = 50;
            dataGridStyle.GridColumnStyles.Add(aCol1);

            dataGrid1.TableStyles.Add(dataGridStyle);


            aCol2.HeaderText = "Title";
            aCol2.MappingName = "Title";
            aCol2.Width = 100;
            dataGridStyle.GridColumnStyles.Add(aCol2);


            dataGridComboBox.HeaderText = "Category";
            dataGridComboBox.MappingName = "Category";
            dataGridComboBox.Width = 125;
            dataGridStyle.GridColumnStyles.Add(dataGridComboBox);

            aCol4.HeaderText = "Discs";
            aCol4.MappingName = "Discs";
            aCol4.Width = 100;
            dataGridStyle.GridColumnStyles.Add(aCol4);

            dataGridComboBox2.HeaderText = "Version";
            dataGridComboBox2.MappingName = "Version";
            dataGridComboBox2.Width = 125;
            dataGridStyle.GridColumnStyles.Add(dataGridComboBox2);

            aCol6.HeaderText = "Boxset";
            aCol6.MappingName = "Boxset";
            aCol6.Width = 100;
            dataGridStyle.GridColumnStyles.Add(aCol6);



           /* aCol7.HeaderText = "Delete";

            aCol7.Width = 100;
            dataGridStyle.GridColumnStyles.Add(aCol7);*/



        }


        private void label1_Click(object sender, System.EventArgs e)
        {

        }



        private void button2_Click(object sender, System.EventArgs e)
        {
            this.Close();

        }

        private void button3_Click(object sender, System.EventArgs e)
        {

        }

        private void label2_Click(object sender, System.EventArgs e)
        {

        }

        private void button4_Click(object sender, System.EventArgs e)
        {
            dataGrid1.Hide();
            label1.Hide();
            Imagescrn();
            Dv = new DataView(Movset1.Tables[0]);
            dataGrid1.DataSource = Dv;
            Dv.RowFilter = "Category = 'HORROR'";
        }

        private void button6_Click(object sender, System.EventArgs e)
        {
            Dv = new DataView(Movset1.Tables[0]);
            dataGrid1.DataSource = Dv;
            Dv.RowFilter = "Category = 'Action/Thriller'";
        }

        private void button8_Click(object sender, System.EventArgs e)
        {
            label1.Hide();
            this.BackgroundImage = Image.FromFile("C:\\Documents and Settings\\Mark\\My Documents\\My Pictures\\drama_pg.jpg");
            Dv = new DataView(Movset1.Tables[0]);
            dataGrid1.DataSource = Dv;
            Dv.RowFilter = "Category = 'Drama'";
        }

        private void button5_Click(object sender, System.EventArgs e)
        {
            Dv = new DataView(Movset1.Tables[0]);
            dataGrid1.DataSource = Dv;
            Dv.RowFilter = "Category = 'Family/Entertainment'";
        }

        private void button7_Click(object sender, System.EventArgs e)
        {
            label1.Hide();
            this.BackgroundImage = Image.FromFile("C:\\Documents and Settings\\Mark\\My Documents\\My Pictures\\scifi_pg.jpg");
            Dv = new DataView(Movset1.Tables[0]);
            dataGrid1.DataSource = Dv;
            Dv.RowFilter = "Category = 'Sci-Fi/Fantasy'";
        }

        private void button9_Click(object sender, System.EventArgs e)
        {
            Dv = new DataView(Movset1.Tables[0]);
            dataGrid1.DataSource = Dv;
            Dv.RowFilter = "Category = 'TV/Series'";
        }

        private void button10_Click(object sender, System.EventArgs e)
        {

            ImageMain();
            dataGrid1.RowHeadersVisible = true;
            dataGrid1.DataSource = Movset1;
            label1.Show();
            Show();
        }


        private void textBox1_TextChanged(object sender, System.EventArgs e)
        {
            Movstring = textBox1.ToString();
        }

        private void dataGrid1_CurrentCellChanged(object sender, System.EventArgs e)
        {
            int CurrnCol = dataGrid1.CurrentCell.ColumnNumber;
            CurCol = dataGrid1.CurrentCell.ColumnNumber;
            CurRow = dataGrid1.CurrentCell.RowNumber;
            dataGrid1.RowHeadersVisible = false;
            // int Currncol = 0;
            // Currncol = dataGrid1.CurrentCell.ColumnNumber;


            if (CurrnCol == 2)
            {

                if (cboControl.DroppedDown = true)
                {
                    this.cboControl.Leave += new EventHandler(cboControl_Leave);


                }


            }
            if (CurrnCol == 4)
            {

                if (cboControl2.DroppedDown = true)
                {

                    this.cboControl2.Leave += new EventHandler(cboControl2_Leave);


                }
            }

            /*if (CurCol == 5)
            {

                string Chkvalue = dataGrid1[CurRow, CurCol - 1].ToString();
                if(Chkvalue == "")
                {
                    dataGrid1[CurRow, CurCol] = false;
                    GblChkval = false;
                    return;


                }                  

            }*/



        }

        private void cboControl_Leave(object sender, EventArgs e)
        {
            Combostr = cboControl.SelectedItem.ToString();
            dataGrid1[CurRow, CurCol] = Combostr;

            //CurRow = 0;
            // CurCol = 0;


        }

        private void cboControl2_Leave(object sender, EventArgs e)
        {

            Combostr = cboControl2.SelectedItem.ToString();
            dataGrid1[CurRow, CurCol] = Combostr;
            //CurRow = 0;
            //CurCol = 0;            


        }
        void CheckBoxOnCheckedChanged(object obj, EventArgs ea)
        {
            dataGrid1[CurRow, CurCol] = ((CheckBox)obj).Checked;
            Invalidate(false);
        }



        private void chk1_Leave(object sender, EventArgs e)
        {

            if (chk1.Checked == true)
            {
                dataGrid1[CurRow, CurCol] = Visible;

            }
            else
                dataGrid1[CurRow, CurCol] = false;


            // CurRow = 0;
            //CurCol = 0;
            return;


        }








        private void Form1_Enter(object sender, System.EventArgs e)
        {
            dataGrid1.RowHeadersVisible = true;

        }

        private void button12_Click(object sender, System.EventArgs e)
        {

            dataGrid1.Show();

        }

        private void Findbtn_Click(object sender, System.EventArgs e)
        {
            Dv = new DataView(Movset1.Tables[0]);
            dataGrid1.DataSource = Dv;
            Dv.RowFilter = "Title ='" + textBox1.Text + "'";
            if (textBox1.Text == "")
            {
                MessageBox.Show("Search failed: Movie Title has not been entered!! ");
                return;
            }

            if (Dv.Count < 1)
            {
                MessageBox.Show("Movie does not exist in MovieBase, please try again");
            }

        }

        private void UpdateSavebtn_Click_1(object sender, System.EventArgs e)
        {
            Mcon.Open();
            UpdateVal = 1;
            if (UpdateVal == 0)
            {
                CurCol = dataGrid1.CurrentCell.ColumnNumber;
                CurRow = dataGrid1.CurrentCell.RowNumber;
                CellValue = dataGrid1[CurRow, CurCol].ToString();
                MessageBox.Show(CellValue.ToString());


                if (CellValue == "")
                {

                    MessageBox.Show("No Fields can be Blank - update failed");
                    Movset1.RejectChanges();
                    ImageMain();
                    CurRow = -1;
                    CurCol = -1;

                    Mcon.Close();
                    return;

                }
                CellValue = dataGrid1[CurRow, CurCol].ToString();
                CurRow = -1;
                CurCol = -1;
            }


            MovAdapt.UpdateCommand = cb.GetUpdateCommand();
            MovAdapt.Update(Movset1.Tables[0]);
            Movset1.AcceptChanges();


            MessageBox.Show("New movie added");

            Mcon.Close();
            UpdateVal = 0;

            dataGrid1.RowHeadersVisible = true;
        }

        private void dataGrid1_MouseUp(object sender, System.Windows.Forms.MouseEventArgs e)
        {

            hitTestGrid = dataGrid1.HitTest(e.X, e.Y);
            if (CurCol == 5)
            {


                    switch (ChkVal)
                    {
                        case 1:
                            ChkVal = 1;
                            dataGrid1[CurRow, CurCol] = false;
                            break;
                        case 2:
                            ChkVal = 2;
                            dataGrid1[CurRow, CurCol] = true;
                            break;                   
                        default:                           
                            break;
                    }

                            if (ChkVal == 1)
                            {
                                ChkVal = 2;
                            }
                            else
                            {
                                ChkVal = 1;
                            }




            }
        }



        private void button13_Click(object sender, EventArgs e)
        {




        }



        private void button3_Click_1(object sender, EventArgs e)
        {
            frm2.Show();

        }


    }
}


















































using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Data.Common;

namespace MovieDiary
{
    public partial class Form2 : Form
    {

        DataView Dv2 = new DataView();
        public DataSet ds2 = new DataSet();
        public static Form1 F1 = new Form1();
        SqlDataAdapter Da2 = new SqlDataAdapter();
        public static int DelVal = 0;
        SqlCommandBuilder cb2 = new SqlCommandBuilder();

        void DSMethod()
        {

            ds2 = Form1.Movset1;
            //Da2 = Form1.MovAdapt;
            Form1.UpdateVal = 1;





        }

        public Form2()
        {

            InitializeComponent();

        }

        public void Form2_Load(object sender, System.EventArgs e)
        {

        }        

        private void label1_Click(object sender, EventArgs e)
        {

        }

        private void button1_Click(object sender, EventArgs e)
        {
            if (textBox1.Text == "")
            {
                MessageBox.Show(" Please enter a title to be deleted ");
                return;             
            }



               DSMethod();
               Dv2 = new DataView(ds2.Tables[0]);
               F1.dataGrid1.DataSource = Dv2;
               Dv2.RowFilter = "Title ='" + textBox1.Text + "'";

               if (Dv2.Count < 1)
               {
                   MessageBox.Show("Movie does not exist in MovieBase, please try again");
                   return;
               }
               else
               {

                   int rownum = (F1.dataGrid1.CurrentCell.RowNumber);
                   Dv2.Delete(rownum);

                   ds2.AcceptChanges();
                   //MovAdapt.UpdateCommand = cb.GetUpdateCommand();
                   //MovAdapt.Update(Movset1.Tables[0]);

                   this.Hide();

                     //Dv2.Table.Rows.Remove(Dv2.Table.Rows.current)

                   MessageBox.Show("Movie has been deleted");

               }





        }
    }
}

A data adapter should have four commands:
1) Select -> to retrieve the data and used in the fill of a datatable
2) Insert -> to put the new rows into the database
3) Update -> to update the row content in the database, and
4) Delete -> to remove the deleted rows from the database.

As far as I can see in your code, only the SELECT and the UPDATE commands are defined for the data adapter.

Hope this helps