Connecting to a SQL Server 2005 Database

[=?Utf-8?B?U2hlcndvb2Q=?=]

Greetings,

I am using Visual C#.NET 2005 (Express Edition) and want to connect to a SQL
Server 2005 (Express Edition) database. When I attempt to compile the code
below, however, I receive the error message:

"Use of unassigned local variable 'con'"

System.Data.SqlClient.SqlConnection con;
con.ConnectionString = "Data Source=HOME-PC\\SQLEXPRESS;Initial
Catalog=Contacts;User ID=sa";
con.Open();

Any ideas as to what I am doing wrong?

Thanks in advance!

[=?UTF-8?B?QXJuZSBWYWpow7hq?=]

Sherwood wrote:

I am using Visual C#.NET 2005 (Express Edition) and want to connect to a SQL
Server 2005 (Express Edition) database. When I attempt to compile the code
below, however, I receive the error message:

"Use of unassigned local variable 'con'"

System.Data.SqlClient.SqlConnection con;
con.ConnectionString = "Data Source=HOME-PC\\SQLEXPRESS;Initial
Catalog=Contacts;User ID=sa";
con.Open();

Any ideas as to what I am doing wrong?

You are missing something like:

con = new SqlConnection();

Arne

[=?Utf-8?B?TXVkYXNzYXIgSGFzc2Fu?=]

Try this

System.Data.SqlClient.SqlConnection con;
con = new System.Data.SqlClient.SqlConnection();
con.ConnectionString = "Data Source=HOME-PC\\SQLEXPRESS;Initial
Catalog=Contacts;User ID=sa";
con.Open();
--
Regards,
Mudassar Hassan
Software Engineer
http://mudassarhassan.spaces.live.com/
"Sherwood" wrote:

Greetings,

I am using Visual C#.NET 2005 (Express Edition) and want to connect to a SQL
Server 2005 (Express Edition) database. When I attempt to compile the code
below, however, I receive the error message:

"Use of unassigned local variable 'con'"

System.Data.SqlClient.SqlConnection con;
con.ConnectionString = "Data Source=HOME-PC\\SQLEXPRESS;Initial
Catalog=Contacts;User ID=sa";
con.Open();

Any ideas as to what I am doing wrong?

Thanks in advance!