private void button1_Click(object sender, EventArgs e)
{
Random rdm=new Random();
DataSet dss = new DataSet();
DataTable dt1 = new DataTable();
dt1.Columns.Add("ID");
dt1.Columns.Add("Name");
dt1.Rows.Add(new object[] { 1, "AA" });
dt1.Rows.Add(new object[] { 2, "BB" });
dt1.Rows.Add(new object[] { 3, "CC" });
dt1.Rows.Add(new object[] { 4, "GG" });
dss.Tables.Add(dt1);
DataSet dsss = new DataSet();
DataTable dt2 = new DataTable();
dt2.Columns.Add("Age");
dt2.Columns.Add("KeyWord");
dt2.Rows.Add(new object[] { 5, "DD" });
dt2.Rows.Add(new object[] { 6, "EE" });
dt2.Rows.Add(new object[] { 7, "FF" });
dt2.Rows.Add(new object[] { 8, "CC" });
dsss.Tables.Add(dt2);
DataSet newds = new DataSet();
newds=AllDataSet(dss, dsss);
}
public DataSet AddDataSet(DataSet ds1, DataSet ds2)
{
if (ds1 == null || ds1.Tables.Count == 0 || ds1.Tables[0].Rows.Count == 0) return null;
DataSet dsnew = ds1.Copy();
if (ds2 == null || ds2.Tables.Count == 0 || ds2.Tables[0].Rows.Count == 0) return dsnew;
for (int j = 0; j < ds2.Tables[0].Columns.Count; j++)
{
DataColumn newdc = new DataColumn();
newdc.ColumnName =ds2.Tables[0].Columns[j].ToString();
dsnew.Tables[0].Columns.Add(newdc);
int index = dsnew.Tables[0].Columns.Count-1;
for (int n = 0; n < ds2.Tables[0].Rows.Count; n++)
{
dsnew.Tables[0].Rows[n][index] = ds2.Tables[0].Rows[n][j].ToString();
}
}
return dsnew;
}
{
Random rdm=new Random();
DataSet dss = new DataSet();
DataTable dt1 = new DataTable();
dt1.Columns.Add("ID");
dt1.Columns.Add("Name");
dt1.Rows.Add(new object[] { 1, "AA" });
dt1.Rows.Add(new object[] { 2, "BB" });
dt1.Rows.Add(new object[] { 3, "CC" });
dt1.Rows.Add(new object[] { 4, "GG" });
dss.Tables.Add(dt1);
DataSet dsss = new DataSet();
DataTable dt2 = new DataTable();
dt2.Columns.Add("Age");
dt2.Columns.Add("KeyWord");
dt2.Rows.Add(new object[] { 5, "DD" });
dt2.Rows.Add(new object[] { 6, "EE" });
dt2.Rows.Add(new object[] { 7, "FF" });
dt2.Rows.Add(new object[] { 8, "CC" });
dsss.Tables.Add(dt2);
DataSet newds = new DataSet();
newds=AllDataSet(dss, dsss);
}
public DataSet AddDataSet(DataSet ds1, DataSet ds2)
{
if (ds1 == null || ds1.Tables.Count == 0 || ds1.Tables[0].Rows.Count == 0) return null;
DataSet dsnew = ds1.Copy();
if (ds2 == null || ds2.Tables.Count == 0 || ds2.Tables[0].Rows.Count == 0) return dsnew;
for (int j = 0; j < ds2.Tables[0].Columns.Count; j++)
{
DataColumn newdc = new DataColumn();
newdc.ColumnName =ds2.Tables[0].Columns[j].ToString();
dsnew.Tables[0].Columns.Add(newdc);
int index = dsnew.Tables[0].Columns.Count-1;
for (int n = 0; n < ds2.Tables[0].Rows.Count; n++)
{
dsnew.Tables[0].Rows[n][index] = ds2.Tables[0].Rows[n][j].ToString();
}
}
return dsnew;
}