多个结果集的查询(使用table显示多个结果集)

最新推荐文章于 2021-04-11 10:20:27 发布

liu_111111

最新推荐文章于 2021-04-11 10:20:27 发布

阅读量1.2k

点赞数

分类专栏：程序

本文链接：https://blog.csdn.net/liu_111111/article/details/8231990

版权

程序专栏收录该内容

121 篇文章 0 订阅

订阅专栏

前台：
<body>
<form id="form1" runat="server">
<div>
<asp:Table ID="Table1" runat="server">
</asp:Table>
</div>
</form>
</body>

后台：
protected void Page_Load(object sender, EventArgs e)
{
string constr = "data source=.;initial catalog=MySchool;User ID=sa;Password=111111";

using (SqlConnection con = new SqlConnection(constr))
{
string sql = "select * from Student;select * from Class";
using (SqlCommand cmd = new SqlCommand(sql, con))
{
con.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
do
{
if (reader.HasRows)
{
while (reader.Read())
{
TableRow trRow = new TableRow();
TableCell tcCell;
for (int i = 0; i < reader.FieldCount; i++)
{
tcCell = new TableCell();
tcCell.BorderStyle = BorderStyle.Solid;
tcCell.BorderWidth = 1;
tcCell.Text = reader.GetValue(i).ToString();
trRow.Cells.Add(tcCell);
}
Table1.Rows.Add(trRow);
}
}
} while (reader.NextResult());
}
}
}
}