Updating an SQL string

Can someone please help me with the following problem.  I am trying to update an sql datatable to show the changes.  But when I run the code below the changes arent saved.   I am currently using SQL Express 5.

using System;

using System.Drawing;

using System.Collections;

using System.ComponentModel;

using System.Windows.Forms;

using System.Data;

using System.Data.SqlClient;

namespace MovieBase1

///

public class Form1 : System.Windows.Forms.Form

private System.Windows.Forms.Button button1;

private System.Windows.Forms.Button button2;

private System.Windows.Forms.Button button3;

private System.Windows.Forms.Button button4;

private System.Windows.Forms.Button button5;

private System.Windows.Forms.Button button6;

private System.Windows.Forms.Label label1;

///

private System.ComponentModel.Container components = null;

public DataSet Movset1 = new DataSet();

public static SqlConnection Mcon = new SqlConnection("workstation id=SHERMAN2;packet size=4096;integrated security=SSPI;data source=\"SH" +

public SqlCommand Movcmd = Mcon.CreateCommand();

private System.Windows.Forms.Button button7;

public SqlDataAdapter MovAdapt = new SqlDataAdapter(null,Mcon);

public Form1()

//

// Required for Windows Form Designer support

//

//

// TODO: Add any constructor code after InitializeComponent call

//

///

protected override void Dispose( bool disposing )

if( disposing )

if (components != null)

base.Dispose( disposing );

#region Windows Form Designer generated code

///

private void InitializeComponent()

this.button1 = new System.Windows.Forms.Button();

this.button2 = new System.Windows.Forms.Button();

this.button3 = new System.Windows.Forms.Button();

this.button4 = new System.Windows.Forms.Button();

this.button5 = new System.Windows.Forms.Button();

this.button6 = new System.Windows.Forms.Button();

this.label1 = new System.Windows.Forms.Label();

this.button7 = new System.Windows.Forms.Button();

this.SuspendLayout();

//

// button1

//

this.button1.Location = new System.Drawing.Point(304, 72);

this.button1.Name = "button1";

this.button1.TabIndex = 0;

this.button1.Text = "Delete Film";

this.button1.Click += new System.EventHandler(this.button1_Click);

//

// button2

//

this.button2.Location = new System.Drawing.Point(328, 120);

this.button2.Name = "button2";

this.button2.TabIndex = 1;

this.button2.Text = "Current Movie Count";

this.button2.Click += new System.EventHandler(this.button2_Click);

//

// button3

//

this.button3.Location = new System.Drawing.Point(336, 168);

this.button3.Name = "button3";

this.button3.TabIndex = 2;

this.button3.Text = "Movie List";

this.button3.Click += new System.EventHandler(this.button3_Click);

//

// button4

//

this.button4.Location = new System.Drawing.Point(336, 208);

this.button4.Name = "button4";

this.button4.TabIndex = 3;

this.button4.Text = "Exit";

this.button4.Click += new System.EventHandler(this.button4_Click);

//

// button5

//

this.button5.Location = new System.Drawing.Point(336, 264);

this.button5.Name = "button5";

this.button5.TabIndex = 4;

this.button5.Text = "button5";

this.button5.Click += new System.EventHandler(this.button5_Click);

//

// button6

//

this.button6.Location = new System.Drawing.Point(328, 16);

this.button6.Name = "button6";

this.button6.TabIndex = 5;

this.button6.Text = "Add Film";

this.button6.Click += new System.EventHandler(this.button6_Click);

//

// label1

//

this.label1.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));

this.label1.Location = new System.Drawing.Point(32, 16);

this.label1.Name = "label1";

this.label1.TabIndex = 6;

this.label1.Text = "Movie Base";

//

// button7

//

this.button7.Location = new System.Drawing.Point(80, 152);

this.button7.Name = "button7";

this.button7.Size = new System.Drawing.Size(168, 23);

this.button7.TabIndex = 7;

this.button7.Text = "button7";

this.button7.Click += new System.EventHandler(this.button7_Click);

//

// Form1

//

this.AccessibleDescription = "public";

this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);

this.ClientSize = new System.Drawing.Size(432, 366);

this.Controls.Add(this.button7);

this.Controls.Add(this.label1);

this.Controls.Add(this.button6);

this.Controls.Add(this.button5);

this.Controls.Add(this.button4);

this.Controls.Add(this.button3);

this.Controls.Add(this.button2);

this.Controls.Add(this.button1);

this.Name = "Form1";

this.Text = "Form1";

this.ResumeLayout(false);

///

static void Main()

Application.Run(new Form1());

private void button6_Click(object sender, System.EventArgs e)

private void button1_Click(object sender, System.EventArgs e)

private void button2_Click(object sender, System.EventArgs e)

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

{ Form3 F3 = new Form3();

private void button4_Click(object sender, System.EventArgs e)

this.Close();

private void button5_Click(object sender, System.EventArgs e)

private void button7_Click(object sender, System.EventArgs e)

---------------------------

any help would be appreciated.......thanks