GridviewLINQ and SQL

Question

Hi Guys I have fetched data using LINQ and given the retrieved data as a datasource to a gridview. When i change the values in the gridview how can i update the grid view in database using LINQ Thanks

Hemant Kumar · Answer

Hi Vipul  As you said that you are updating the Data GridCell.At last you want to save the value in DBNow i think you have written a update command for Updation.Please call the DataBind Method which was written by you. Any Queries Feel Free to Ask Me: -)

Tulasi · Answer

Hi Vipul we can update gridview data by rowediting and rowupdating events . in that event we have to write code to update database using linq  one way is  add dbml file to the project and update values  again bind data to gridview

Vipul Kelkar · Answer

Hi Hemanth I am not editing the database. I want to edit the DataGridView CELL and save updated value to the database. Can this be done using LINQ sorry if the prev ques was confusing :)

Hemant Kumar · Answer

Hi Vipul I think you have written a separate method for data binding the gridview using LINQ.Just try to call the same method after doing the modification's in the database. It will work sure. If any queries ask me

Gridview,LINQ and SQL