none
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?

     

    Thanks,

     

    Ralph

    Sunday, February 9, 2014 11:46 PM

Answers

  • 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 - www.ContrivedExample.com

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