Load All gridview rows with data from dataset

Question

Hi I have a gridview to which i am adding rows dynamically at the click event of a button placed in gridview footer template. When i want to update data. I have to load the gridview with all the rows required. I get the sql table data in the dataset object and then i have to load this in the gridview. How can i do this? Only one row gets loaded when i use this code: DataSet DSContact = DMLObj.Load_DataSet(Usp_LoadData ContactPerson idf); foreach (GridViewRow row in GVContactPerson.Rows) { ((TextBox)row.FindControl(txtContactName)).Text=DSContact.Tables[0].Rows[0][ContactName].ToString(); ((TextBox)row.FindControl(txtemail)).Text = DSContact.Tables[0].Rows[0][ContactEmailID].ToString(); ((TextBox)row.FindControl(txtmob1)).Text = DSContact.Tables[0].Rows[0][ContactMobile].ToString(); Session[contact] = ((TextBox)row.FindControl(txtContactName)).Text; string pid = Convert.ToString(DMLObj.getid(Select ContactPersonID from tbl_ContactPersonDetails where ContactName=' + Session[contact].ToString() + ')); Session[contactID] = pid; }

B M Suchitra · Answer

@Mamta  My gridview is same as below: http://www.aspsnippets.com/Articles/Adding-Dynamic-Rows-in-ASP.Net-GridView-Control-with-TextBoxes.aspx what i need to do is load this gridview with data from the dataset which may have any no of rows. Then update it.. I have problem loading this gridview as i am able to load the gridview with only one row

Mamta M · Answer

Hi suchitra Just saw your response. What error are you getting now? How many rows are present in the DataSet table? -Mamta

Raghvendr Singh · Answer

Hi For that task follow the process as bellow. 1.First declare a session table eg. Session[Table1]. 2.declare a datatable 'dt'. 3.Place the session table into datatable 'dt'. 4.add a row in table 'dt' on button click event and at once place the table 'dt' into session table to preserve data. 5.simply bind session table in gridview.

B M Suchitra · Answer

Hi Mamta I tried out with that but still not getting the desired result.. I am adding rows to gridview using this concept: http://www.aspsnippets.com/Articles/Adding-Dynamic-Rows-in-ASP.Net-GridView-Control-with-TextBoxes.aspx

Mamta M · Answer

This is because you havent changed the row index at all. ((TextBox)row.FindControl(txtContactName)).Text=DSContact.Tables[0]. Rows[0] [ContactName].ToString(); See the bolded text that's always 0. That must be incremented for each iteration of the loop. Use an int variable such as i that's incremented and give Rows[i].