using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Xml.Linq;
 
public partial class NetProgrammingHelp : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
    }
 
    protected void Button1_Click(object sender, EventArgs e)
    {
        string connString = @"server=Databse1;Integrated security=true;database=master";
        string cmd = "SELECT * FROM dept;SELECT * FROM emp";
        SqlDataAdapter adapter = new SqlDataAdapter(cmd, connString);
        DataSet ds = new DataSet();
        adapter.Fill(ds);
 
        var dept = ds.Tables[0].AsEnumerable();
        var emp = ds.Tables[1].AsEnumerable();
 
        var data = from d in dept join m in emp
                                   on d.Field<int>("deptno") equals m.Field<int>("deptno")
                                   select new { empno=m.Field<int>("empno"),ename=m.Field <string>("ename"),
                                       dname=d.Field <string>("dname")};
        //var res = from d in dept
          //             select new { dno=d.Field<int>("deptno"),dn=d.Field<string>("dname"),loc=d.Field<string>("loc"));
 
        GridView1.DataSource = data;
        GridView1.DataBind();
    }
}