Unable To Connect .NET To SQL Express 5!!!!

Cannot someone please help me with following problem.  I am trying to create a program to update a sql datbase from.NET 2003.  I am doing this by using SQL Server Express 5.  The problem is, is that when I run the program and click the button to view the table in SQL Express 5 I keep getting an 'System.NullReferenceException' and the table is not shown. When I look at the debug details it says that 'object reference not set to an instance of an object'.

Am not sure where am goin wrong as the connection is opened to the local server in SQL Express and I have created a connection object and initialised it to the address fo the datatable in SQL. 

Please find below the code I am working on which shows the connection string in question and the table being called in button 6  which causes the exception.

Any help would be greatly appreciated....thanks 

 

 

using System;

using System.Drawing;

using System.Collections;

using System.ComponentModel;

using System.Windows.Forms;

using System.Data;

using System.Data.SqlClient;namespace MovieBase

{

/// <summary>

/// Summary description for Form1.

/// </summary>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.Label label1;private System.Windows.Forms.Button button4;

private System.Windows.Forms.Button button5;private System.Data.SqlClient.SqlConnection sqlConnection1;

private System.Windows.Forms.ComboBox GengreList;private System.Windows.Forms.Button button6;

private System.Windows.Forms.Button button7;private System.Data.SqlClient.SqlCommand sqlSelectCommand1;

private System.Data.SqlClient.SqlCommand sqlInsertCommand1;private System.Data.SqlClient.SqlDataAdapter sqlDataAdapter1;

private System.Windows.Forms.Label label2;public DataSet MDSet = new DataSet();

SqlDataAdapter MyAdapt;private System.Data.SqlClient.SqlCommand sqlSelectCommand2;

private System.Data.SqlClient.SqlCommand sqlInsertCommand2;private System.Data.SqlClient.SqlDataAdapter sqlDataAdapter2;public SqlConnection MovCon = new SqlConnection("Data Source = SHERMAN/SQLEXPRESS;Initial Catalog= MovieDBase;User Id=myUsername;Password=myPassword");

 

 

 

 

 

/// <summary>

/// Required designer variable.

/// </summary>private System.ComponentModel.Container components = null;public Form1()

{

//

// Required for Windows Form Designer support

//

InitializeComponent();

 

 

//

// 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.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(Form1));

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

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

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

this.sqlConnection1 = new System.Data.SqlClient.SqlConnection();this.GengreList = new System.Windows.Forms.ComboBox();

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

this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand();

this.sqlDataAdapter1 = new System.Data.SqlClient.SqlDataAdapter();this.label2 = new System.Windows.Forms.Label();

this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand();this.sqlInsertCommand2 = new System.Data.SqlClient.SqlCommand();

this.sqlDataAdapter2 = new System.Data.SqlClient.SqlDataAdapter();this.SuspendLayout();

//

// button1

// this.button1.Location = new System.Drawing.Point(184, 168);

this.button1.Name = "button1";this.button1.Size = new System.Drawing.Size(96, 23);

this.button1.TabIndex = 0;this.button1.Text = "Add A Movie";

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

//

// button2

// this.button2.Location = new System.Drawing.Point(184, 248);

this.button2.Name = "button2";this.button2.Size = new System.Drawing.Size(96, 23);

this.button2.TabIndex = 1;this.button2.Text = "Delete A Movie";

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

//

// button3

// this.button3.Location = new System.Drawing.Point(184, 208);

this.button3.Name = "button3";this.button3.Size = new System.Drawing.Size(96, 23);

this.button3.TabIndex = 2;this.button3.Text = "View Movies";

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

//

// label1

// this.label1.Font = new System.Drawing.Font("Myriad Web Pro", 14.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));

this.label1.Location = new System.Drawing.Point(280, 8);this.label1.Name = "label1";

this.label1.Size = new System.Drawing.Size(120, 24);this.label1.TabIndex = 3;

this.label1.Text = "MOVIEBASE";

//

// button4

// this.button4.Location = new System.Drawing.Point(448, 344);

this.button4.Name = "button4";this.button4.Size = new System.Drawing.Size(192, 23);

this.button4.TabIndex = 4;this.button4.Text = "Current Movie Count";

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

//

// button5

// this.button5.Location = new System.Drawing.Point(496, 112);

this.button5.Name = "button5";this.button5.Size = new System.Drawing.Size(128, 32);

this.button5.TabIndex = 5;this.button5.Text = "Find Movie";

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

//

// sqlConnection1

// this.sqlConnection1.ConnectionString = "workstation id=SHERMAN;packet size=4096;integrated security=SSPI;data source="SHE" +

"RMAN\SQLEXPRESS";persist security info=False;initial catalog=MovieDBase";this.sqlConnection1.InfoMessage += new System.Data.SqlClient.SqlInfoMessageEventHandler(this.sqlConnection1_InfoMessage);

//

// GengreList

// this.GengreList.BackColor = System.Drawing.SystemColors.InactiveCaptionText;this.GengreList.Items.AddRange(new object[] {

"Horror",

"Comedy",

"Family/Entertainment",

"Drama",

"Boxsets",

"Sci -fi/Fantasy"});this.GengreList.Location = new System.Drawing.Point(184, 344);

this.GengreList.Name = "GengreList";this.GengreList.Size = new System.Drawing.Size(121, 21);

this.GengreList.TabIndex = 6;

//

// button6

// this.button6.Location = new System.Drawing.Point(264, 104);

this.button6.Name = "button6";this.button6.Size = new System.Drawing.Size(160, 40);

this.button6.TabIndex = 7;this.button6.Text = "View Movie List";

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

//

// button7

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

this.button7.Location = new System.Drawing.Point(360, 432);this.button7.Name = "button7";

this.button7.Size = new System.Drawing.Size(104, 40);this.button7.TabIndex = 8;

this.button7.Text = "Exit Movie Base";this.button7.Click += new System.EventHandler(this.button7_Click);

//

// sqlSelectCommand1

// this.sqlSelectCommand1.CommandText = "SELECT [Item Number], [Movie Title], Genre, [Date of Release], Director FROM [Mov" +

"Table 1]";this.sqlSelectCommand1.Connection = this.sqlConnection1;

//

// sqlInsertCommand1

// this.sqlInsertCommand1.CommandText = "INSERT INTO [MovTable 1] ([Item Number], [Movie Title], Genre, [Date of Release]," +

" Director) VALUES (@Param1, @Param2, @Genre, @Param3, @Director); SELECT [Item N" +

"umber], [Movie Title], Genre, [Date of Release], Director FROM [MovTable 1]";this.sqlInsertCommand1.Connection = this.sqlConnection1;

this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param1", System.Data.SqlDbType.VarChar, 50, "Item Number"));this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param2", System.Data.SqlDbType.VarChar, 50, "Movie Title"));

this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Genre", System.Data.SqlDbType.VarChar, 50, "Genre"));this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param3", System.Data.SqlDbType.VarChar, 50, "Date of Release"));

this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Director", System.Data.SqlDbType.VarChar, 50, "Director"));

//

// sqlDataAdapter1

// this.sqlDataAdapter1.InsertCommand = this.sqlInsertCommand1;

this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand1;this.sqlDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {

new System.Data.Common.DataTableMapping("Table", "MovTable 1", new System.Data.Common.DataColumnMapping[] {new System.Data.Common.DataColumnMapping("Item Number", "Item Number"),

new System.Data.Common.DataColumnMapping("Movie Title", "Movie Title"),new System.Data.Common.DataColumnMapping("Genre", "Genre"),

new System.Data.Common.DataColumnMapping("Date of Release", "Date of Release"),new System.Data.Common.DataColumnMapping("Director", "Director")})});

this.sqlDataAdapter1.RowUpdated += new System.Data.SqlClient.SqlRowUpdatedEventHandler(this.sqlDataAdapter1_RowUpdated);

//

// label2

// this.label2.Font = new System.Drawing.Font("Myriad Web Pro", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0)));

this.label2.Location = new System.Drawing.Point(64, 344);this.label2.Name = "label2";

this.label2.Size = new System.Drawing.Size(120, 23);this.label2.TabIndex = 9;

this.label2.Text = "Genres";

//

// sqlSelectCommand2

// this.sqlSelectCommand2.CommandText = "SELECT [Item Number], [Movie Title], Genre, [Date of Release], Director FROM [Mov" +

"Table 1]";this.sqlSelectCommand2.Connection = this.sqlConnection1;

//

// sqlInsertCommand2

// this.sqlInsertCommand2.CommandText = "INSERT INTO [MovTable 1] ([Item Number], [Movie Title], Genre, [Date of Release]," +

" Director) VALUES (@Param1, @Param2, @Genre, @Param3, @Director); SELECT [Item N" +

"umber], [Movie Title], Genre, [Date of Release], Director FROM [MovTable 1]";this.sqlInsertCommand2.Connection = this.sqlConnection1;

this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param1", System.Data.SqlDbType.VarChar, 50, "Item Number"));this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param2", System.Data.SqlDbType.VarChar, 50, "Movie Title"));

this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Genre", System.Data.SqlDbType.VarChar, 50, "Genre"));this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param3", System.Data.SqlDbType.VarChar, 50, "Date of Release"));

this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Director", System.Data.SqlDbType.VarChar, 50, "Director"));

//

// sqlDataAdapter2

// this.sqlDataAdapter2.InsertCommand = this.sqlInsertCommand2;

this.sqlDataAdapter2.SelectCommand = this.sqlSelectCommand2;this.sqlDataAdapter2.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {

new System.Data.Common.DataTableMapping("Table", "MovTable 1", new System.Data.Common.DataColumnMapping[] {new System.Data.Common.DataColumnMapping("Item Number", "Item Number"),

new System.Data.Common.DataColumnMapping("Movie Title", "Movie Title"),new System.Data.Common.DataColumnMapping("Genre", "Genre"),

new System.Data.Common.DataColumnMapping("Date of Release", "Date of Release"),new System.Data.Common.DataColumnMapping("Director", "Director")})});

//

// Form1

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

this.BackColor = System.Drawing.SystemColors.InactiveCaption;this.BackgroundImage = ((System.Drawing.Image)(resources.GetObject("$this.BackgroundImage")));

this.ClientSize = new System.Drawing.Size(704, 502);this.Controls.Add(this.label2);

this.Controls.Add(this.button7);this.Controls.Add(this.button6);

this.Controls.Add(this.GengreList);this.Controls.Add(this.button5);

this.Controls.Add(this.button4);this.Controls.Add(this.label1);

this.Controls.Add(this.button3);this.Controls.Add(this.button2);

this.Controls.Add(this.button1);this.Name = "Form1";

this.Text = "Form1";this.ResumeLayout(false);

}

#endregion

/// <summary>

/// The main entry point for the application.

/// </summary>

[STAThread]static void Main()

{Application.Run(new Form1());

 

}private void sqlConnection1_InfoMessage(object sender, System.Data.SqlClient.SqlInfoMessageEventArgs e)

{

 

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

{

MessageBox.Show("///Under Construction");

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

{

MessageBox.Show("///Under Construction");

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

{

MessageBox.Show("///Under Construction");

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

{

MessageBox.Show("///Under Construction");

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

{

MessageBox.Show("There is currently no movie count available");

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

{

 Form2 F2 = new Form2();

sqlConnection1.Open();

MyAdapt.Fill(MDSet, "MovTable 1");

F2.dataGrid1.DataSource = MDSet;

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

{this.Close();

sqlConnection1.Close();

}private void sqlDataAdapter1_RowUpdated(object sender, System.Data.SqlClient.SqlRowUpdatedEventArgs e)

{

 

}

}

}