Databases
StackOverflow2013
Postsdbo
POproblem in gridview with LINQ
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POproblem in gridview with LINQ
    text
    copied!<p>when i am trying to display result in gridview using LINQ i am getting this error message."Both DataSource and DataSourceID are defined on 'GridView1'. Remove one definition." i am not getting any clue what to do? Here is my code </p> <pre><code>protected void SelectBtn_Click(object sender, EventArgs e) { ShowEmployee(); } private void ShowEmployee() { DataClassesDataContext db = new DataClassesDataContext(); var name = from E in db.Employees orderby E.Age ascending select E; GridView1.DataSource = name; GridView1.DataBind(); } protected void InsertBtn_Click(object sender, EventArgs e) { int id = Convert.ToInt32(TxtId.Text); string name = TxtName.Text; string address = TxtAddress.Text; int age = Convert.ToInt32(TxtAge.Text); DataClassesDataContext db = new DataClassesDataContext(); try { Employee emp = new Employee { EmployeeId = id, Name = name, Address = address, Age = age }; db.Employees.InsertOnSubmit(emp); db.SubmitChanges(); LblMessage.Text = "Employee has been added successfully"; TxtId.Text = ""; TxtName.Text = ""; TxtAddress.Text = ""; TxtAge.Text = ""; ShowEmployee(); } catch (Exception ee) { LblMessage.Text = ee.Message.ToString(); } } protected void UpdateBtn_Click(object sender, EventArgs e) { string name=TxtName.Text; string address=TxtAddress.Text; DataClassesDataContext db = new DataClassesDataContext(); Employee emp = db.Employees.FirstOrDefault(E =&gt; E.Name.StartsWith(name)); emp.Address = address; db.SubmitChanges(); ShowEmployee(); } protected void DeleteBtn_Click(object sender, EventArgs e) { DataClassesDataContext db = new DataClassesDataContext(); Employee emp = db.Employees.Single(E =&gt; E.Address.StartsWith("Delhi")); db.Employees.DeleteOnSubmit(emp); db.SubmitChanges(); ShowEmployee(); } </code></pre> <p> </p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload