Smithbr Posted June 3, 2003 Posted June 3, 2003 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 don't even know where to start. Thanks Quote
*Experts* Nerseus Posted June 5, 2003 *Experts* Posted June 5, 2003 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 it's a matter of setting the label's Text property to the string you're retreiving. If you still can't get it, show us the code you tried (such as setting up a connection, filling a datareader and then pulling out the values) and we'll help you out. -Nerseus Quote "I want to stand as close to the edge as I can without going over. Out on the edge you see all the kinds of things you can't see from the center." - Kurt Vonnegut
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.