Append records to a Gridview from a control

Question

Hello all.
I have a simple aspx page with a textbox which is the control, gridview and SQLDatasource which connects to a view on our SQL server. It succesfully finds a record when an ID is entered into the textbox.

Here is my problem. I do not wish to just show one record at a time. I wish to build the gridview from the records found, in other words appending records to the gridview.

Has anyone had experiance in this please?

Amit Gupta · Answer

Hey Chris You can merge the multiple DataSource and bind them in gridview. Take a look to below snippet: // Suppose you have datatable filled with Rows DataTable dt = new DataTable(); DataTable dt2 = new DataTable() // Merging both the tables dt2.Merge(dt); dt2.AcceptChanges(); GridView1.DataSource = dt2; GridView1.DataBind(); Check out the below link for your reference http://www.c-sharpcorner.com/UploadFile/0c1bb2/merging-multiple-datatables-into-single-datatable-using-asp/ Do let me know if it solves your problem

Amit Gupta · Answer

What does it means I do not wish to just show one record at a time. I wish to build the gridview from the records found in other words appending records to the gridview. Clarify your question to get best solution. If I am not wrong are you asking not to clear the gridview and further results should be merged with the gridview?

Chris Johnson · Answer

Thank you Amit ;-)