I have two columns in one table on a SQL server and I'm programming using VB.NET. The Table name is "Lots". The two column names are "Batch" and "LotNumber". The SqlDataAdapter is already filled with both columns.
I have a DropDownList that shows all of the LotNumbers. When the user selects a LotNumber I want the appropriate Batch ID to be displayed in a text box. The LotNumbers and Batch ID's are in no way the same or have any related characters. In other words, when the user selects the LotNumber the Batch ID for that row the LotNumber is located is returned to a textbox.
My DropDownList box is called = "lotNumber"
My TextBox is called = "batchid"