HeatherV

I've been following a tutorial using Northwind and multitable stuff. I've created some storedProcedures and views, and then added those storedProcedures to the DataSet Designer via drag'n'drop. However, in my toolbox under StoredProcedure Components, only my three initial additions to the DataSet Designer appear along with the NorthwindDataset. I tried reseting the Toolbox (which did wonders for the icons), but I still cannot see my additional six tableAdapters (including the QueriesTableAdapters). I know that I can create these through code, but I'm trying to follow the tutorial here! Seriously though, what's going on

Thanks,
Heather


Re: Visual Basic General missing storedprocedures in toolbox

cybertaz69

Not sure what tutorial your using so I don't know excatly what they are trying to show.

Only one tableadapter per table should show. Each table can have multi queries and procedure calls in the same instance..... Unless the tutorial is opening 6 different tables will you have six tableadapters......






Re: Visual Basic General missing storedprocedures in toolbox

HeatherV

Hmm...I'm using multiple tables, so I'm not sure that's the issue.

Display in Toolbox:

CustomersByNameTableAdapter^
CustOrdersDetail
TableAdapter*
CustOrdersOrders
TableAdapter*

Don't Display in Toolbox:
GetCustomerShippingInfo*
GetProductList^
GetShipperList^
GetUnitPrice*
ValidateEmployee*
QueriesTableAdapter(AddOrder*,AddOrderDetail*)

All display in NorthwindDataSet.xsd(Dataset Designer)
* indicates Stored Procedure
^ indicates a View

Some of the tables used in Stored Procedures/Views: Customers, Employees, Order Details, Orders, Shippers

Come to think of it - the ones that don't display are the one's that I created...
So here's what I did to create them, and perhaps you can see a step I missed:
(This is using only one SQL Server DB Connection to Northwind)
  1. Right-clicked on View folder in Server Explorer and selected "Add New View"
  2. Added SQL stuff and saved (no SQL errors).
  3. View appeared in list of DB Views.
  4. Opened NorthwindDataSet.xsd(Dataset Designer) and dragged in new View from Server Explorer.
  5. View appeared on Dataset Designer.
  6. (Did same thing with Stored Procedures)
Heather




Re: Visual Basic General missing storedprocedures in toolbox

cybertaz69

GetCustomerShippingInfo* >>>> Should see CustomersTableAdapter 1
GetProductList^ >>>> Should see ProductTableAdapter 2
GetShipperList^ >>>> Should see ShippersTableAdapter 3
GetUnitPrice* >>>> Should see ProductTableAdapter Same as above
ValidateEmployee* >>>> Should see EmployeeTableAdapter 4

Orders >>>> Should see OrdersTableAdapter

If you add view to a table not yet created and it doen't show up after a drag and drop to the Dataset designer then Run a Solution Rebuild....

Post if they still don't show.....






Re: Visual Basic General missing storedprocedures in toolbox

HeatherV

Worked beautifully. Thanks!