Add rows to gridview along with data and later save it to database table

Question

Hi, I need to create a gridview in which i can add data and later save all those rows data to table. How to do that please help

Mayur Gujrathi · Answer

decalre text1 ,text2 as new textbox as TextBox text1 = new TextBox(); TextBox text2 = new TextBox(); where you are writting your save logic then foreach (GridViewRow grow in grid1.Rows) { text1= grow .FindControl("TextBox1"); text2= grow .FindControl("TextBox2"); --- ---- text7= grow .FindControl("TextBox7"); then save values text1.Text,text2.Text in databse one by one } Mark as accepted if this solves your problem

nagham ghandour · Answer

well I told you the main points, in my case I had a master detail gridviews, and using objectdatasource, so the detail was filled on selectedindexchange of the master, what you ave to do is creating the datatable as session variable, button add is used to shoe the footer where u add the new row, clicking add again u add the row to tha datatable and show the footer empty to add second row, finally clickink insert of the footer is to send all data to be saved to database, please start by trying the way and I'll try to assist you as your case need.

Nethra R S · Answer

Hi Nagham, We are here to know the long story please explain how to do that,will be grateful please

nagham ghandour · Answer

well for me it was a long story: 1st I used the footer of the grid for inserting new rows, sowing or hiding the footer as needed then, I've created a session variable on load Session["MyDataTable"]=null filling the grid using objectdatasource with the appropriate function the using Add button to add the row to the datatable, and when Save sending all rows of DataTable to be inserted.

Nethra R S · Answer

Hi Mayur , Thats a good one.. But how to save the rows data entered into sql table?

Mayur Gujrathi · Answer

Please find the attached folder

Add rows to gridview along with data and later save it to database table

Answers (6)