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

VB2008 BASIC COPY TABLE TO ANOTHER

Hi EXPERTS

I HAVE A LARGE DATATABLE    DTR
I WOULD LIKE TO COPY PART OF DTR TO DTR2 WHERE DTR.KEYCODE COLUMN = 'SOLD'
THEN DISPLAY DTR2 IN A GRID



PLEASE HELP
0
b001
Asked:
b001
1 Solution
 
Bob LearnedCommented:
You might be able to use Linq-to-DataSet, and use a Where expression.

LINQ To DataSet Samples - DataSet Loading examples
http://msdn.microsoft.com/en-us/vstudio/bb738020#copydtable

Public Sub DataSetLinq117a()

    Dim customers = TestDS.Tables("Customers").AsEnumerable()
    Dim orders = TestDS.Tables("Orders").AsEnumerable()

    Dim query = From o In orders _
                Where o("Total") < 500.0# _
                Select o


    Dim results = query.CopyToDataTable()

Open in new window


    PrettyPrintDataTable(results)
End Sub
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

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