c# SQL连接

 

string m_connectionString = string.Format(@"Data Source=.\SQLEXPRESS; User ID=sa; Password=~password1234");

using (SqlConnection con=new SqlConnection(m_connectionString))

{

  using (SqlCommand cmd = con.CreateCommand()) 
                {
                    cmd.CommandText = "select * from s.dbo.T_Users where  UserName=@UserName";

}

}

有用链接

（1）Microsoft SQL Server Error 18456 Login Failed for User

   

 http://www.youtube.com/watch?v=aU8RhjdkCoE

（2）NOTE：

down votaccepted

If you are marking the connection string with @ to make it a literal you should only use one backslash in the data source DataSource=.\SQLEXPRESS

7down voteaccepted

If you are marking the connection string with @ to make it a literal you should only use one backslash in the data source DataSource=.\SQLEXPRESS