Append records to a Gridview from a control

Chris Johnson

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?

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta9y ago
Accepted 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
Chris Johnson9y ago
Thank you Amit ;-)
Amit Gupta9y ago
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?