学步园

两个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[i][j];
  }
  dtParent.Rows.Add(dr);
 }
 return ds.Tables["ACCOUNT"].DefaultView;
}