protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
using (var entity = new EntityFrameworkTestEntities())
{
if (e.CommandName.Equals("detail"))
{
int index = Convert.ToInt32(e.CommandArgument);
string personid = GridView1.DataKeys[index].Value.ToString();
hiddenprimary.Value = personid;
var query = from i in entity.PersonCRUDs
where i.PersonID == personid
select i
;
foreach (var x in query)
{
personprimary.Value = personid;
personlast.Value = x.LastName;
personfirst.Value = x.FirstName;
personaddress.Value = x.Address;
personcity.Value = x.City;
}
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "step1confirm", "$('#myModal').modal();", true);
}
}
}
public Array getmethodLinq()
{
using (var entity = new EntityFrameworkTestEntities())
{
var first = (from r in entity.People.AsQueryable()
select new { r.PersonID, r.FirstName, r.LastName, r.City, r.Address });
return(first.ToArray());
}
}
protected void Page_Load(object sender, EventArgs e)
{
using (var entity = new EntityFrameworkTestEntities())
{
var first = (from r in entity.People
select new { r.PersonID, r.FirstName, r.LastName, r.City, r.Address }).ToList();
GridView1.DataSource = first;
GridView1.DataBind();
var second = (from r in entity.OrderProducts
select new { r.OrderId, r.OrderNumber, r.PersonID }).ToList();
GridView2.DataSource = second;
GridView2.DataBind();
}
}
