string strConn = "...";
string strSQL = "...";
SqlConnection sqlConn = new SqlConnection(strConn);SqlCommand sqlComm = new SqlCommand(strSQL,sqlConn);
sqlConn.Open();
SqlDataReader sqlReader = sqlComm.ExecuteReader();
sqlConn.Close();SqlCommand sqlComm1 = new SqlCommand(strSQL,sqlConn);
sqlConn.Open();
SqlDataReader sqlReader1 = sqlComm.ExecuteReader();
sqlConn.Close();
string strSQL = "...";
SqlConnection sqlConn = new SqlConnection(strConn);SqlCommand sqlComm = new SqlCommand(strSQL,sqlConn);
sqlConn.Open();
SqlDataReader sqlReader = sqlComm.ExecuteReader();
sqlConn.Close();SqlCommand sqlComm1 = new SqlCommand(strSQL,sqlConn);
sqlConn.Open();
SqlDataReader sqlReader1 = sqlComm.ExecuteReader();
sqlConn.Close();
SqlCommand sqlComm = new SqlCommand(strSQL,sqlConn);
SqlDataReader sqlReader = sqlComm.ExecuteReader();
sqlReader.Close();
独占连接的
你可以考虑用dataset