I am trying to set up a VB.net program that will allow the user to enter an invoice number into a textbox, then click a retrieve command button, from this I want to populate 4 labels with the corresponding data relevant to the invoice number. I have the database linked using the OleDbConnection, OleDbDataAdapter, and DsIvoice. I have only programed in VB 6.0 but now I am using VB.Net so I am kinda lost as to all the new ways of doing things. Does anyone know what code I will need to put behind the Retrieve command button including how to define the variables. Later, I want this data to be carried over so that I can use a Select Case procedure to determine a commission rate based on the Salesrep, product, and vendor (all things I want to get pulled up when you retrieve the data associated witht he invoice number). Any help would be great..I just dont even know where to start. Thanks
Data Retrieval Question..Please Help
- Thread starter Smithbr
- Start date
Nerseus
Danner
I would first look at the help files for the DataReader. They contain the raw code you would want to pull out a few values. Then its a matter of setting the labels Text property to the string youre retreiving.
If you still cant get it, show us the code you tried (such as setting up a connection, filling a datareader and then pulling out the values) and well help you out.
-Nerseus
If you still cant get it, show us the code you tried (such as setting up a connection, filling a datareader and then pulling out the values) and well help you out.
-Nerseus