• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 7744
  • Last Modified:

VB.NET Add Row To DataSet

I have a gridview that i bound to a dataset. In my footer I have an option for add new row. When they click on that i run the below code it will add a row the way i want it to. If i run the code again it will remove the row it just added and reset the way the page originally loaded.

i am thinking i have to do something with the gridview to accept the changes before i read the datasource again

Any thoughts?
Dim packages As New DataSet
        packages = Me.GridView2.DataSource
 
        Dim packagerow As DataRow
 
        packagerow = packages.Tables(0).NewRow()
        packagerow(0) = "Package " & packages.Tables(0).Rows.Count + 1
        packagerow(1) = "1"
        packages.Tables(0).Rows.Add(packagerow)
 
        packages.AcceptChanges()
 
        Me.GridView2.DataSource = packages
        Me.GridView2.DataBind()
 
        packages = Nothing

Open in new window

0
jimseiwert
Asked:
jimseiwert
1 Solution
 
jfmadorCommented:
Hello, we use AcceptChanges after Updating your DataSet to your Database. If you use AcceptChanges after adding a row to your dataset your dataset schema won't know that this row was added, then it won't post it to your database.

Also you don't need to reset the datasource and databind, these are already set with your grid view. Adding a row to your table will automatically add the row to your datagrid

0
 
EYoungCommented:
Thanks for the input
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now