Where The Hell is My Stored Procedure?

  • Thread starter Thread starter Crazy Cat
  • Start date Start date
C

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 said:
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
Click to expand...

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
 
Back
Top