Ask Experts Questions for FREE Help !
Ask
    vacuit's Avatar
    vacuit Posts: 0, Reputation: 1
    New Member
     
    #1

    Aug 14, 2007, 10:15 AM
    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!

Check out some similar questions!

Access Database [ 5 Answers ]

I keep getting this error message, what should I do? I tried to delete the record where the error appears but the system won't allow me to. (The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.)

Database search [ 2 Answers ]

How do I search within DATABASE.. as Google searches within the HTML pages.. like we write anything and get the result.. same I want a search type for DATABASE.. So from where I should start or what procedure should be followed..

Database [ 2 Answers ]

Hi there! I would like to have some detailed information about This topic:- Specify the hardware needed to support Database system, supporting your reasoning with argument and a detailed rationale. Waiting for your reply Cheers Reetika

How do I connect to a database [ 2 Answers ]

Hi, I'm having problems connecting to my database. I have had my site working perfectly on brinkster, but when I've moved it over to my new host it doesn't work. How do I know what way I should be connecting to the database i.e. DNS-less, system DNS or file DNS etc. Could some one...

Database [ 1 Answers ]

In a database I have inputed a subform. The subform adds up totals of plants by adding Price*quantity. That is fine, the problem I have is that I want to have a box that adds up all the plants totals to give an overal price. Anyway you can help me? Thanks


View more questions Search
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.