Monday, 22 June 2015

How to  binding Gridview using Linq and Populated Records.


Code Given Below


 using (DataClassesDataContext Dbcontext = new DataClassesDataContext())
        {

            Table_11 Emp = new Table_11();
            Emp.Ename = TxtName.Text;
            Emp.Eempno = TxtEmpno.Text;
            Emp.Eamt = TxtAmount.Text;
            Dbcontext.Table_11s.InsertOnSubmit(Emp);
            Dbcontext.SubmitChanges();
            lblMsg.Text = "SucessfullY Saved!..";

            if (Cmd_Save.Text == "Update")
            {
                var products = (from p in Dbcontext.Table_11s
                                where p.id == intid
                                select p).Single();
                Dbcontext.SubmitChanges();  
            }
        }

private void BindGrdis()
    {
        using (DataClassesDataContext Dbcontext = new DataClassesDataContext())
        {
            var Test = from p in Dbcontext.Table_11s select new { Ename = p.Ename, Eempno = p.Eempno, Eamt = p.Eamt };

            grd1.DataSource = Test; 
            grd1.DataBind(); 

        }
    }


No comments:

Post a Comment