站长论坛

标题: 两个DataTable来绑定到DataGrid (转) [打印本页]

作者: webptr 时间: 2007-9-19 23:45
标题: 两个DataTable来绑定到DataGrid (转)
private DataView CreateDataView()
{
SqlDataAdapter cmd=null;
DataSet ds=null;
string cmdSelect = "Select * from table1";
string cmdSelect1 = "Select * from table2";

cmd = new SqlDataAdapter(cmdSelect, Conn);
ds = new DataSet();
cmd.Fill(ds, "ACCOUNT");

if(Conn.State != ConnectionState.Closed)
Conn.Close();
cmd=new SqlDataAdapter(cmdSelect1, Conn);
cmd.Fill(ds, "ACCOUNT1");

DataTable dtParent=ds.Tables["ACCOUNT"];
DataTable dtChild=ds.Tables["ACCOUNT1"];
DataRow dr;
for(int i=0;i<dtChild.Rows.Count;i++)
{
dr=dtParent.NewRow();
for(int j=0;j<dtParent.Columns.Count;j++)
{
dr[j]=dtChild.Rows[j];
}
dtParent.Rows.Add(dr);
}
return ds.Tables["ACCOUNT"].DefaultView;
}

欢迎光临站长论坛 (http://www.tzlink.com/bbs/)