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 [MVP]" wrote:

> 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)
> ____________________________________________________________________________________________
> "Mark" <(E-Mail Removed)> wrote in message
> news:9D5246E2-B3C8-4B68-9DC2-(E-Mail Removed)...
> > 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
>