ASP.NET

select studentname as [Name] from tab_student
union all
select employeename as [Name] from tab_employee

DataTable dt1 = new DataTable("student");
dt1.Columns.Add("Name", typeof(string));
dt1.Rows.Add("a"); dt1.Rows.Add("b"); dt1.Rows.Add("c");


DataTable dt2 = new DataTable("employee");
dt2.Columns.Add("Name", typeof(string));
dt2.Rows.Add("x"); dt2.Rows.Add("y"); dt2.Rows.Add("z");


DataTable dt3 = new DataTable("student_employee");
dt3.Columns.Add("StudentName", typeof(string));
dt3.Columns.Add("EmployeeName", typeof(string));


//further you can add an IF condition to check the max dt.row.count here
for (int i = 0; i < dt1.Rows.Count; i++ )
{
    for (int j = 0; j < dt2.Rows.Count; j++)
    {
        dt3.Rows.Add(dt1.Rows[i]["Name"].ToString(), dt2.Rows[i]["Name"].ToString());
        break;
    }
}

//bind the dt3 with gridview here

Piyush Vardhan Singh wrote:

how run setup from aspx page?