向dataset中添加datatable

DataSet ds = new DataSet();
DataTable dt1 = new DataTable();
DataTable dt2 = new DataTable();
ds.Tables.Add(dt1);
ds.Tables.Add(dt2);

 

 

  dt = sqlhelper.ExecuteQuery(sql, CommandType.Text);


            myDataSet.Tables.Add(dt);

            if (myDataSet.Tables[0].Rows.Count > 0)
            {
                    foreach (DataRow dr in myDataSet.Tables[0].Rows)
                    {
  

 

textBox1.Visible = false;

            DataTable dt1 = personinfo.displayInfo(this.account);
            //SqlDataAdapter da = new SqlDataAdapter();
            //DataSet ds = new DataSet();
            //ds.Tables.Add(dt1);
            dataGridView1.DataSource = dt1;
            this.dataGridView1.AllowUserToResizeColumns = true;
            this.dataGridView1.Au