Convert this VFP code into VB.NET RRS feed

  • Question

  • I have two table :
        Item(ProductID c(15), ProductName c(50))
        Order(OrderID c(10), ProductID c(15)

    In Foxpro, in order to make a new table with my own condition, I use this command
    Select * from Item where ProductID not in (select productID from Order) into cursor NewItem

    It is very easy to make a new table by use above select sql expression. But it seem to be extremely hard to do so in VB.NET. In VB.NET I also have two similar Datatables, but I don't know how to have a third Datatable with above condition? How can I do it?

    Thank you very much,

    Saturday, June 30, 2012 11:33 PM


All replies