MultipleActiveResultSets=true;

加上这句话可以定义两个com对象

不会发生com冲突

 

connection语句

string strConnect = "Data Source=localhost;uid=sa;pwd=123456;Database=infor;Integrated Security = true;MultipleActiveResultSets=true;";

SqlConnection con = new SqlConnection(strConnect);
if (con.State == ConnectionState.Closed)
{
con.Open();

}

 

command语句

string n1 = "select * from managerlist where userlogin ='" + d_txt1.Text.ToString() + "'";
string n2 = "select * from managerlist where password ='" + d_txt2.Text.ToString() + "'";
SqlCommand comm = new SqlCommand(n1, con);
SqlCommand com = new SqlCommand(n2, con);
SqlDataReader dr1 = comm.ExecuteReader();
SqlDataReader dr2 = com.ExecuteReader();

 

dr1.Read()------读取的结果