OleDbDataReader中放两个以上记录集的问题!
如下代码:
string sqlstr = "select top 10 [id],topic,makedate,ishot from news where newstype=@newstype order by makedate desc; select * from newstype where [ID]=@newstype";
OleDbConnection conn = new OleDbConnection(connstr);
OleDbCommand cmd = new OleDbCommand(sqlstr,conn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@newstype",OleDbType.Integer);
cmd.Parameters["@newstype"].Value = Convert.ToUInt32(newstype);
try
{
cmd.Connection.Open();
OleDbDataReader dr = cmd.ExecuteReader();
sitenewsdg.DataSource = dr;
sitenewsdg.DataBind();
dr.NextResult();
dr.Read();
Label1.Text = Convert.ToString(dr[1]);
dr.Close();
}
catch(Exception ex)
{
Response.Write(ex.ToString());
}
finally
{
cmd.Dispose();
conn.Close();
}
结果老是报错!其实也就是想实现前一个记录集放到DataGrid里面
后一个记录集的结果显示在Lable里面
求教!!!!