I'm a VB.net beginner.
My project has a Data Source called On_OrderDataSet
which works great. I'm able to access objects in this data source using code like this:
Dim dtCustomer As DataTable = On_OrderDataSet.Tables("Tbl_Customers")
So, I added a stored parameter-ized query, named Qry_Customers
, using the Add option in the .xsd file. Screenshot shows it. Problem is that I can't figure out how to use Qry_Customers in my code. I'd like to do something like:
Dim dtCustomer As DataTable = On_OrderDataSet.Queries("Qry_Customers")
But it doesn't work.
How do I do fill a DataTable or DataRow object using Qry_Customers? Code would be helpful.