Programmatically change TableAdapter Query

[Ultrawhack]

How can I programatically change TableAdapter Queries ?

My DGV is bound to a (access db) TableAdapter/Bindingsource Query and I need to programmatically change the query sql behind the tableadapter. And hopefully the DGV will update itself.

Can someone walk me through this ?

 

[jdavis2]

Try this thread, I just asked the same question basically.

http://www.vbdotnetforums.com/showthread.php?t=14823&goto=newpost

 

[cjard]

You dont, you establish more SQLs in the TA to fill the datatable. The contents of the DGV wont update automatically as it is only showing you what the datatable contains. TO have the DGV change, you must fill the data table with different data