You searched for the word(s): userid:645188

More Search Options

RSS Available

• Re: Issue with LINQ when trying to update rows inside a GridView

  Hi, myInfoList list can contain multiple items that are retrieved there by ID, that's why I cant use SingleOrDefault in this case. Also, that's the reason I need to use foreach loop to go through the items. And since I'm having a GridView I need to loop through GridView rows too. So there are currently two foreach loops (nested). Do you think this is causing problems?

  Posted to Data Access and ObjectDataSource Control (Forum) by k000der on 10/6/2009

• Re: Issue with LINQ when trying to update rows inside a GridView

  Ok, now I can see your point. It gets a bit confusing at times especially when you are dealing with two nested loops and several objects. Thanks :)

  Posted to Data Access and ObjectDataSource Control (Forum) by k000der on 10/6/2009

• Re: Issue with LINQ when trying to update rows inside a GridView

  Anyone, could you please help?

  Posted to Data Access and ObjectDataSource Control (Forum) by k000der on 10/1/2009

• Re: Unable to update multiple rows to database with LINQ

  Anyone, please? Has anyone managed to do a multiple row update with foreach loop?

  Posted to Data Access and ObjectDataSource Control (Forum) by k000der on 9/30/2009

• Re: Populate checked/unchecked values from db to Checkboxes inside GridView

  Thanks for your answers. I got it now :)

  Posted to Data Presentation Controls (Forum) by k000der on 9/30/2009

• Re: Unable to update multiple rows to database with LINQ

  OK, I think I got it now. There is nothing wrong with the foreach loop, it's has something to do with the GridView's foreach loop this code is inside of. Let me post another topic on this issue.

  Posted to Data Access and ObjectDataSource Control (Forum) by k000der on 9/30/2009

• Issue with LINQ when trying to update rows inside a GridView

  My case is the following: I have a GridView with checkboxes and I want to be able to update checked/unchecked values back to database based on user selections. I'm able to insert new values to database, but haven't been able to do this when updating. Few things to note: - I'm trying to achieve this whenever a button is clicked - DataContext (myContext) is already created outside of the button event handler - IsChecked is a field in MyTable table - I have tried to place SubmitChanges to

  Posted to Data Access and ObjectDataSource Control (Forum) by k000der on 9/30/2009

• Unable to update multiple rows to database with LINQ

  My code looks like this: ASPX.CS: var myList = myContext.GetInfoByID(id); foreach (MyTable u in myList) { u.IsChecked = false; u.UpdateBy = Page.User.Identity.Name; u.UpdateDate = DateTime.UtcNow; } myContext.SubmitChanges(); DAL: public IEnumerable<MyTable> GetInfoByID(int id) { return from l in this.MyTables where l.ID == id select l; } I'm activating my UPDATE operation inside button click and a) unable to update values back to db b) unable to see what kind of SQL is generated by LINQ

  Posted to Data Access and ObjectDataSource Control (Forum) by k000der on 9/29/2009

• Re: Unable to update multiple rows to database with LINQ

  Looks very confusing comparing to what ScottGu explained: http://weblogs.asp.net/scottgu/archive/2007/07/11/linq-to-sql-part-4-updating-our-database.aspx And the same question remains: why my code doesn't work?

  Posted to Data Access and ObjectDataSource Control (Forum) by k000der on 9/29/2009

• Populate checked/unchecked values from db to Checkboxes inside GridView

  How can I achieve that? What GridView event should I use? Could you please provide me examples how to do it?

  Posted to Data Presentation Controls (Forum) by k000der on 9/29/2009