Bind ComboBox

Question

Hi I want to bind a combox with one table and Display information should come from another table Eg: Product Category should display and code should be stored in Product table help

rencels · Answer

Just make a SQL statement to connect with inner join for 2 tables then store the results in a datatable. On a ComboBox: combox.DisplayMember = ProductCategory combox.Valuemember = ProductCategoryID If you use it in asp you have to add combox.DataBind