ado.net connection using c#

Question

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

Bechir Bejaoui · 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 velusamy · Answer

Here I mention the connection string using Ado.Net Syntax: Example:

Bechir Bejaoui · Answer

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 prasad · Answer

This one is correct SqlConnection con = new SqlConnection("Server=.\SQLExpress;Database=patient;uid=sa;pwd=;");

Manish Dwivedi · Answer

Hi, Try this SqlConnection con = new SqlConnection("Server=.;Database=patient;uid=sa;pwd=;");