Insert Data in Typed DataSet Table

Posted on 2006-05-05
Last Modified: 2010-04-17

I get some records from Data Grid to DataTable which is no part of Typed DataSet.
Now in want to get records from That DataTable and stored to Typed Data Set Table
Question by:MuhammadAdil
    LVL 10

    Expert Comment


    See this link which has some function for Sql Helper class

    LVL 6

    Author Comment

    i m working with MS ACCESS
    LVL 14

    Accepted Solution

    You can populate a typed a DataSet just like you populate a normal DataSet.

    Here's an example on copying the contents of a DataTable to another DataTable of a typed DataSet:

            Dim tds As New myTypedDataSet
            Dim ds As New DataSet
            Dim i As Integer
            For i = 1 To ds.Tables(0).Rows.Count
                tds.Tables(0).Rows.Add(ds.Tables(0).Rows(i - 1).ItemArray)


      Nayer Naguib

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Suggested Solutions

    Title # Comments Views Activity
    sameEnds challenge 3 78
    commonTwo  challenge 63 68
    changePi Challenge 15 55
    Path of Workbook 3 30
    Purpose To explain how to place a textual stamp on a PDF document.  This is commonly referred to as an annotation, or possibly a watermark, but a watermark is generally different in that it is somewhat translucent.  Watermark’s may be text or graph…
    RIA (Rich Internet Application) tools are interactive internet applications which have many of the characteristics of desktop applications. The RIA tools typically deliver output either by the way of a site-specific browser or via browser plug-in. T…
    In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now