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.Sql Client.SqlConne ction con;
con.ConnectionS tring = "Data Source=HOME-PC\\SQLEXPRESS; Initial
Catalog=Contact s;User ID=sa";
con.Open();

Any ideas as to what I am doing wrong?

Thanks in advance!

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

Re: Connecting to a SQL Server 2005 Database

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.Sql Client.SqlConne ction con;
con.ConnectionS tring = "Data Source=HOME-PC\\SQLEXPRESS; Initial
Catalog=Contact s;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?=]

RE: Connecting to a SQL Server 2005 Database

Try this

System.Data.Sql Client.SqlConne ction con;
con = new System.Data.Sql Client.SqlConne ction();
con.ConnectionS tring = "Data Source=HOME-PC\\SQLEXPRESS; Initial
Catalog=Contact s;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.Sql Client.SqlConne ction con;
con.ConnectionS tring = "Data Source=HOME-PC\\SQLEXPRESS; Initial
Catalog=Contact s;User ID=sa";
con.Open();
>
Any ideas as to what I am doing wrong?
>
Thanks in advance!