Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Visual Basic (https://www.askmehelpdesk.com/forumdisplay.php?f=469)
-   -   Saving a new datatable to the database (https://www.askmehelpdesk.com/showthread.php?t=119481)

  • Aug 14, 2007, 10:15 AM
    vacuit
    Saving a new datatable to the database
    Visual Basic 2005
    I want to save a copy of a datatable (that the user has changed) with a new name back to the database (Access)

    I have this code to save a copy with a new name to the dataset... how do I then update the database (without changing the original datatable)? Essentially I want to add a new datatable to the database.

    Dim dt As New DataTable
    dt = MyDataSet.OriginalDataTable.Copy
    dt.TableName = mytextbox.text
    MyDataSet.Tables.Add(dt)

    thank you!

  • All times are GMT -7. The time now is 01:24 AM.