利用SqlDataReader检索数据:
private void Search()
{
StrConn="Initial Catalog=study;Data Source=(local);user id=sa;password=sa;Connect Timeout=30";
SqlConnection myConnection=new SqlConnection(StrConn);
SqlCommand myCommand=new SqlCommand();
myCommand.Connection=myConnection;
myCommand.CommandText="select * from datareader;"+"select * from dr";
myConnection.Open();
myDr=myCommand.ExecuteReader();
do{
while(myDr.Read())
{
this.comboBox1.Items.Add(this.myDr[0].ToString());
this.comboBox2.Items.Add(this.myDr[1].ToString());
}
}while(myDr.NextResult());
}
值得注意的地方:
可以用SqlCommand返回多个记录集,两条SQL语句用分号隔开,如红色标注部分