Can't edit DataGridView

In ASP.NET 3.5, I'm following this example: http://weblogs.asp.net/scottgu/archive/2007/07/16/linq-to-sql-part-5-binding-ui-using-the-asp-linqdatasource-control.aspx.  My LINQ source is coming from a DLL that I reference by project, in my asp.net app project.  In the datasource, I select the Advanced button allow LINQ to control edits and inserts.  I don't get the edit/inset options in the grid's smart tag until I select "*" in the datasource.  If I select a single column, the edit/insert options aren't in the smart tag.  What causes that?

Also, how can I make the insert option appear in the grid?
brettrAsked:
Who is Participating?
 
QPRConnect With a Mentor Commented:
In order to allow edits/deletes your datasource must contain the primary key column for that table.
This way the IDE can create the SQL statements required for updates/deletes

otherwise we end up with....
Update myTable setColumn1 = "HelloWorld" where ?????

If the datasource contains the primary key (say myID) then the statement becomes
Update myTable setColumn1 = "HelloWorld" where myID = <value>
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.