Trying to do something that seems like it should be really simple, but I'm new to VB (All my development has been asp). I have a form with 4 text boxes: Quantity, Sku, Description, Week, Year.

The user enters the quantity, then the sku. As soon as they leave the sku field, I want to look up the description from a table in the database and place it in the Description field, they then enter the week and year, and upon clicking a button, everything is added to a different table in the database.

It seems like it should be an easy thing to fire a stored procedure once the focus goes on the description box,(taking a parameter from the sku field and looking up the description) and throwing the result into the description textbox, but I can't figure out how to do it yet. I'm sure I'll figure it out, but it's really frustrating to find my way around in this new environment.

imports system.data.oledb
Public Class Form1

Dim theCommand as new oledbCommand
Dim theConnection as new oledbConnection
Dim teQuery as String

Private Sub TextBox1_LostFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles TextBox1.LostFocus

theConnection.connectionstring = [connectin string as a string value]

theCommand = new oledbcommand(theQuery, theConnection)

theCommand.Connection.open()

Dim reader as oledbdatareader = theCommand.executereader(commandbehavior.singlerow )

reader.read()

textbox1.text = reader(0)

theCommand.Connection.Close()

end sub

End Class

hope this helps.

Only two things are infinite, the universe and human stupidity, and I'm not sure about the former.
Albert Einstein
US (German-born) physicist (1879 - 1955)