Where The Hell is My Stored Procedure?

[Crazy Cat]

I created a non result returning query using the Dataset Designer that
calls a stored procedure in Visual Basic .NET Professional 2005 and
then saved the dataset file. I can see the query in the designer , but
can't access it anywhere in code. In the designer it appears as a box
titled QueriesTableAdapter with the stored procedure name in the box.
If I type the name of the dataset to access it's members, I don't see
either QueriesTableAdapter, or the stored procedure. What the hell
gives?

Please help,

Thanks

[Crazy Cat]

Crazy Cat wrote:

I created a non result returning query using the Dataset Designer that
calls a stored procedure in Visual Basic .NET Professional 2005 and
then saved the dataset file. I can see the query in the designer , but
can't access it anywhere in code. In the designer it appears as a box
titled QueriesTableAdapter with the stored procedure name in the box.
If I type the name of the dataset to access it's members, I don't see
either QueriesTableAdapter, or the stored procedure. What the hell
gives?

Please help,

Thanks

Never mind. After finally finding documentation on calling Stored
Procedures from .NET using TableAdapters in the online documentation I
realized I did not drag the new class into my project and also didn't
realize that the tableadapters are not a member of the DataSet but a
separate class. Boy do I feel dumb.

Thanks for reading my rant,

Crazy