Insert Data in Typed DataSet Table


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
LVL 6
MuhammadAdilAsked:
Who is Participating?
 
nayernaguibCommented:
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
        SqlDataAdapter1.Fill(ds)
        For i = 1 To ds.Tables(0).Rows.Count
            tds.Tables(0).Rows.Add(ds.Tables(0).Rows(i - 1).ItemArray)
        Next

_______________

  Nayer Naguib
0
 
SystemExpertCommented:
Hi,

See this link which has some function for Sql Helper class

http://www.businessanyplace.net/?p=daabcf

Thanks
0
 
MuhammadAdilAuthor Commented:
i m working with MS ACCESS
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.