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

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

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.

Hi Nagham,

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

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.

Hi Mayur ,

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

Please find the attached folder