bind record to grid without storing in databse

1. Example for adding code in Datatable

DataTable dt = new DataTable();

//Add Datacolumn
DataColumn workCol = dt.Columns.Add("FirstName", typeof(String));

dt.Columns.Add("LastName", typeof(String));
dt.Columns.Add("Blog", typeof(String));
dt.Columns.Add("City", typeof(String));
dt.Columns.Add("Country", typeof(String));

//Add in the datarow
DataRow newRow = dt.NewRow();

newRow["firstname"] = "Arun";
newRow["lastname"] = "Prakash";
newRow["Blog"] = "http://royalarun.blogspot.com/";
newRow["city"] = "Coimbatore";
newRow["country"] = "India";

dt.Rows.Add(newRow);


2. You can store the datatable in Viewstate, and then bind the record in grid, Like wise if any new thing is added add new row in the datatable and update the view state datatable.Then bind in grid,

3. Finally insert all the records using Bulk Insert Datatable into SQL Server using SqlBulkCopy in C#, check below link

http://www.morgantechspace.com/2013/08/bulk-insert-records-into-sql-server.html[^]