Sorry if this topic has been posted before.

How do I populate a dataset or datatable with the contents of a gridview control?

Basically, I want to add a new row to the gridview without destroying the exisitng contents of the gridview.

To preserve the data between callbacks, I want to get the existing gridview data and add one row to it and then rebind the gridview to reflect the latest addition.

Any ideas?

how are you changing the datagrid?

I'm a junior coder myself, but datagrid is just a display device. It has to get it's information from your datareader or dataset. So by the time you see your information populated in the datagrid, everything is finished. All you have to do is update your dataset back to the database so that the changes are saved.

-------------------------

Whatever you can do or dream you can, begin it. Boldness has genius, power and magic in it. Begin it now.
-Johann von Goethe

When Two Hearts Race... Both Win.
-Dove Chocolate Wrapper

Chroniclemaster1, Founder of www.EarthChronicle.com
A Growing History of our Planet, by our Planet, for our Planet.

I am not using a datagrid I am using two gridviews. The first gridview is populated by a sqldatasource object.

When the user clicks a button, the RowCommand event fires, and I use code to add a record to the 2nd gridview.

This technique works well for the latest record.

The problem is I need to preserve the second gridview's contents and add another row to it programmatically.

So I want to create a datatable and load it with the 2nd gridview's data, then add the latest record to it and rebind the 2nd gridview with the datatable.

I found a way. I get a collection of gridviewrows and then loop through them to add them to the new datatable. Then, add the new row, and bind to the gridview. My RowCommand sub for this is below (without the Try/Catch blocks).

I hope this helps someone else:
Protected Sub gridSubs_RowCommand(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCommandEventArgs ) Handles gridSubs.RowCommand

If e.CommandName = "AddToCart" Then
            'first get the row that was clicked
            Dim i As Integer = Convert.ToInt32(e.CommandArgument)
            Dim dr As GridViewRow = gridSubs.Rows(i) 'gridsubs is first gridview that holds subscriptions
            Dim origrow As GridViewRow
            Dim dt As DataTable = New System.Data.DataTable("OrderTable")
            Dim ds As New DataSet
            Dim column As DataColumn
            Dim row As DataRow
            'next get the orders table so that we can add the new row to it
            Dim gvr(gridOrders.Rows.Count - 1) As GridViewRow 'gridOrders is 2nd gridview that holds new additions selected from gridSubs
            gridOrders.Rows.CopyTo(gvr, 0)

            'now add the columns to the data table
            column = New DataColumn
            column.DataType = System.Type.GetType("System.String")
            column.ColumnName = "subid"
            column.ReadOnly = True
            column.Unique = True
            dt.Columns.Add(column)

            column = New DataColumn
            column.DataType = System.Type.GetType("System.String")
            column.ColumnName = "subname"
            column.Unique = True
            column.ReadOnly = True
            dt.Columns.Add(column)

            column = New DataColumn
            column.DataType = System.Type.GetType("System.String")
            column.ColumnName = "subprice"
            column.Unique = True
            column.ReadOnly = True
            dt.Columns.Add(column)

            'set the primary key
            Dim PrimaryKeyColumns(0) As DataColumn
            PrimaryKeyColumns(0) = dt.Columns("subid")
            dt.PrimaryKey = PrimaryKeyColumns

            'now add the datatable to the dataset
            ds.Tables.Add(dt)

            'now add the previous orders back to the datatable
            For Each origrow In gvr
                row = dt.NewRow
                row("subid") = origrow.Cells(0).Text
                row("subname") = origrow.Cells(1).Text
                row("subprice") = origrow.Cells(2).Text
                dt.Rows.Add(row)
            Next

            'now add the new row
            row = dt.NewRow
            row("subid") = dr.Cells(0).Text
            row("subname") = dr.Cells(1).Text
            row("subprice") = dr.Cells(3).Text
            dt.Rows.Add(row)

            'finally, bind the updated datatable to the gridview
            gridOrders.DataSource = ds
            gridOrders.DataBind()
        End If
end sub