I need to create a user control that looks like the image in the attached pdf.
The first two columns will be a datagridview from a SQL query. I know how to do this.
The 3rd column is a combo box that will be populated by a SQL query so the user can use the drop down to select a customer ID. I know how to do this.
The 4th column with be a text box or a grid view or something ( I don't know what control to use for this). But when the Customer ID in column 3 is selected, T-SQL will pull the corresponding customer name from the Customer table and supply the name in column 4. I know how to write the SQL to retrieve the Customer Name, but I'm not sure what kind of control to use for Column 4.
Then I need to put them all together so for each line in the datagridview (columns 1 and 2), there is a corresponding line in column 3 that can be used for drop down selection and a line in column 4 that can be populated by the Customer Name as soon as the Customer ID is selected.