Gridview,LINQ 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 DB,Now 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

Answers (4)