TableAdapter - Custom Select Query

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Hi -

I'm working in VS2008, C# and am adding a Select Query to the TableAdapter.

It's simple:
Select ID, Name From myTable
Where ID = @id

So in code I excute the Fill method:
this.myTableTableAdapter.FillbyID(this.myDataSet.myTable, 14);

Where/How at runtime can I see the resolved Select statement? Which would
look like:
Select ID, Name From myTable
Where ID = 14

Thank you,
Mark
 
William -

Very handy.

Thank you,
Mark

William Vaughn said:
If you're using SQL Server, start the Profiler--you'll see everything being
done by any of your applications in real time.

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker’s Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________
 
Back
Top