Hi,
I am having problems with two queries that I am trying to create.
I am using VB.NET and have made a connection to ADO.NET.
First, I have a form that has one label that must display the total number of records in a database once the search button is pressed.
Second, I have a form with a combo box to select an item and then a search button takes you to a results form that must display in datagrid.
Does anyone have any examples of code. I am not sure as to the structure of the query and how to establish connection . I know the first is COUNT(*) VCode FROM VIDEO- I think- The other a select statement. My biggest problem is not knowing where to place the query and link the dataadapter in code to retrive the query.
Thanks
Kristy
I am having problems with two queries that I am trying to create.
I am using VB.NET and have made a connection to ADO.NET.
First, I have a form that has one label that must display the total number of records in a database once the search button is pressed.
Second, I have a form with a combo box to select an item and then a search button takes you to a results form that must display in datagrid.
Does anyone have any examples of code. I am not sure as to the structure of the query and how to establish connection . I know the first is COUNT(*) VCode FROM VIDEO- I think- The other a select statement. My biggest problem is not knowing where to place the query and link the dataadapter in code to retrive the query.
Thanks
Kristy