SQL connection string in C#

[ShuckyD]

---

Im working on a program that is eventually going to be deployed via wireless scanners on our companys WiFi. As i am working on getting the app built i want to make sure it links to our SQL database before i try writing much code in it. Here is the connection string that i came up with via MSDN and other various sources.

		public void ConnectToSql ()
		{
			System.Data.SqlClient.SqlConnection conn = 
				new System.Data.SqlClient.SqlConnection ();
			// TODO: Modify the connection string and include any
			// additional required properties for your database.
			conn.ConnectionString = 
				"integrated security=SSPI;data source=TEST-SQL;" +
				"user id=user;password=pass;" +
				"persist security info=False;database=TESTDB";
			try
			{
				conn.Open();
				// Insert code to process data.
				MessageBox.Show("Hello","Hello");
				
			}
			catch (SqlException ex)
			{
				MessageBox.Show(ex.Message ,ex.Number.ToString() );
			}

I was wondering if that is how i would want to pass the username and password to it, or is there another way to do so. I was reading about passing explicit credentials to a SQL server and i think this is the way it wants me to do it. Although the above code doesnt work quite right? Any suggestions or does anyone know how i should be structuring the ConnString if i am in fact doing it wrong?

[Iturea]

I don't know how your SQL Server is set up but if you can authenticate the client application with the SQL Server via Windows Authentication then this would be the ideal solution concidering you won't be exposing a username and password.

A connection string of this type would be something similiar to:

[This would work for ASP.NET C#]
conn.ConnectionString = "Data Source=YourServer;Initial Catalog=YourDB;Integrated Security=SSPI";

You show: Integrated Security=SSPI in your connection string already. Thats windows authentication. You won't need to supply a user or password with that enabled. You will just need to make sure the client can communicate with the server through windows authentication.

[ShuckyD]

thats iturea, that string helped me and then i had to make sure i passed it a user id and password, i had to create a domain user for this program

[SNK111]

Check this link ( Shahrar Nour Khondokar - Research into embedding SQL in C# and Java ) for details on how to connect to SQL Server database from C#.NET database applications as well as Java database applications. It also describes how to pass embedded SQL queries, calling stored procedures, pass parameters etc.

[liam_web]

C# connection string with sample source code

C# ADO.NET Connection String

webber