ado.net connection using c#

durga prasad

Hi,
I want to know what is the connection string for ADO.Net

I have used this one
SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=patient;uid=sa;pwd=;");

but it is throwing some sql execption,
any suggestions

Thanks in Advance,
A.Durga Prasad

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bechir Bejaoui17y ago
Accepted answer
To connect to a 2008 sql server data base

Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;

To connect to 2005 sql server

Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;

To connect to an Sql server compact edition for pocket PC

Data Source=MyData.sdf;File Mode=Exclusive;Persist Security Info=False;
geetha velusamy4y ago
Here I mention the connection string using Ado.Net
Syntax:
Example:
Bechir Bejaoui17y ago
OK I give you a trick of how to get the right connection string using Visual Studio

I suppose here to get the connection string to an access bata base which is located in C:\

Download this file it contains a small video that I have done for you to show you how to to this
http://rapidshare.com/files/211385845/getTheRightConnectionstring.zip.html

The exactly same procedure could be done for SQL server express edition except that you have to enter user id and password in case of SQL server

after the connection succed you expand the tag + of the connection string section and then you copy the connection string using the mouse finally you can use it within your code without worrying about it will works or won' t work d ;-)
durga prasad17y ago
This one is correct
SqlConnection con = new SqlConnection("Server=.\\SQLExpress;Database=patient;uid=sa;pwd=;");
Blocked Account17y ago
Hi,
Try this

SqlConnection con = new SqlConnection("Server=.;Database=patient;uid=sa;pwd=;");