protected void Page_Load(object sender, EventArgs e)
{
context = new AdventureWorks2014Entities();
// var query = context.Departments.Select((x) => x.Name);
// var json=Newtonsoft.Json.JsonConvert.SerializeObject(query.ToList());
var temp = Request.QueryString["group"];
var query2 = from departments in context.Departments
where departments.GroupName == temp
select new
{
departments.DepartmentID,
departments.Name,
departments.GroupName,
departments.ModifiedDate
};
var json = Newtonsoft.Json.JsonConvert.SerializeObject(query2.ToList());
Response.Clear();
Response.ContentType = "application/json; charset=utf-8";
Response.Write(json);
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
context = new AdventureWorks2014Entities();
var query = context.Departments.Select((x) => x.GroupName).Distinct();
var json = Newtonsoft.Json.JsonConvert.SerializeObject(query.ToList());
Response.Clear();
Response.ContentType = "application/json; charset=utf-8";
Response.Write(json);
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
context = new AdventureWorks2014Entities();
var query = from departments in context.Departments
select departments;
GridView1.DataSource = query.ToList();
GridView1.DataBind();
var query2 = context.Departments.Select(group => group.GroupName).Distinct();
DropDownList1.DataSource = query2.ToList();
DropDownList1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
context = new AdventureWorks2014Entities();
XElement element = new XElement("Departments",
(from departments in context.Departments
select new
{
departments.DepartmentID,
departments.Name,
departments.GroupName,
departments.ModifiedDate
}).ToList().Select(x =>
new XElement("Department", new XElement("DepartmentID", x.DepartmentID),
new XElement("Name", x.Name),
new XElement("GroupName", x.GroupName),
new XElement("ModifiedDate", x.ModifiedDate)
)));
Response.Clear();
Response.ContentType = "application/xml; charset=utf-8";
Response.Write(element);
Response.End();
}