SQL连接

SQL连接语句

using System.Data.SqlClient;using System.Data.Sql;SqlConnection con = new SqlConnection("Data Source=COMWBOY;uid=sa;pwd=123456;database=yiyuan");                   //打开连接                   con.Open();                   //SQL语句                   string str = "select * from Admin where userid='" + this.userid.Text + "'and password='" + this.password.Text + "'";                   //建立数据库执行对象                   SqlCommand com = new SqlCommand(str, con);                   SqlDataReader dr = com.ExecuteReader();

若在Data Source中只能赋值IP地址而不能赋值服务器名.那问题是出在SQL中.应该把验证方式该为混合模式