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