Tableadapters and SQL RRS feed

  • Question

  • Hello,


    I used the Tableadapter wizard to create a Tableadapter that is composed of two  tables via a SQL statement. I need to be able to specify a condition programmatically (like where ID = 1). Is there an easy way to modify the Tableadapter’s SQL statement, or should I be looking at adding a parameter to the Tableadapter?





    Sunday, February 9, 2014 11:46 PM


  • In the tableadapter designer you can right-click a query and choose configure to add parameters. You can also add any number of additional queries to the TA from the designer.

    Bob -

    • Marked as answer by Ralph65 Tuesday, February 11, 2014 12:52 AM
    Monday, February 10, 2014 1:33 PM