Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 251
  • 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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