I have a LINQ query that I use to populate a datagrid. When I fill grid I cannot change any of the cells. I know I will need specific query to change my actual table, but changing the grid has never been an issue for me. Here is LINQ query.
Dim curScores = From s In db.Schedules
Join t1 In db.Teams On s.HomeID Equals t1.Teamid
Join t2 In db.Teams On s.AwayID Equals t2.Teamid
Where s.Week = Me.tscboWeeks.Text And s.Season = "2014"
Select s.id, HId = s.HomeID, Home = t1.TeamName, s.HScore,
AId = s.AwayID, Away = t2.TeamName, s.AScore