using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using System.Data.Common;
public partial class DataAdapter方式的查询数据行 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
DataSet ds=new DataSet();
DataTable dt_Userlist = null;
DataTable dt_Deptlist = null;
DataRow dr=null;
string sqlconnstr = "server=GISTAR-CE;database=HC_MDOC;uid=sa;pwd=;";
SqlConnection sqlconn = new SqlConnection(sqlconnstr);
SqlDataAdapter sqlda = new SqlDataAdapter("select * from Userlist;select * from Deptlist", sqlconn);//SelectCommand关联的连接对象不必手动打开。如果该连接在读取执行前处于关闭状态,那么在获取数据时它会被自动打开,读取完毕后自动关闭。如果连接已被手动打开,则会一直保持该状态,直到手动关闭。
DataTableMapping dtm1, dtm2;//表映射机制,内存表名称和源表名称
dtm1 = sqlda.TableMappings.Add("Userlist", "Userlist");
dtm2 = sqlda.TableMappings.Add("Userlist1", "Deptlist");
sqlda.Fill(ds, "Userlist");
//dt = ds.Tables["Userlist"];
//dt2 = ds.Tables["Userlist1"];//返回多个结果集,第一个结果集为Userlist,其他的表依次为Userlist1、Userlist2。默认的话,查询生成的第一个结果集的名词默认为Table,如果该查询生成了多个结果集,其他的表会依次在该默认名称后面追加索引号,如Table1、Table2等。
dt_Userlist = ds.Tables["Userlist"];
dt_Deptlist = ds.Tables["Deptlist"];
for (int i = 0; i < dt_Userlist.Rows.Count; i++)
{
dr = dt_Userlist.Rows[i];
Label_showUserlist.Text += "用户ID:" + dr["userid"] + "---";
Label_showUserlist.Text += "用户名字:" + dr["username"] + "<br />";
}
for (int i = 0; i < dt_Deptlist.Rows.Count; i++)
{
dr = dt_Deptlist.Rows[i];
Label_showDeptlist.Text += "部门ID:" + dr["deptid"] + "---";
Label_showDeptlist.Text += "部门名字:" + dr["deptname"] + "<br />";
}
}
}
DataAdapter填充多个table至ds
最新推荐文章于 2023-10-17 15:12:49 发布