|
I have a very simple form with a single datagrid on it. The datagrid is a basic drag and drop auto datagrid based on a table in a sql express database. The table has 3 fields, ID, List, and value. ID is a standard autonumber, List and Value are strings. I also placed an unbound combo box setup and a DrowDownList. I set the list of items in the combo box as design time. The datagrid I hide the ID and List columns. The basic idea is I want the user to be able to select the list from the combo box and enter the values for the selected list. I set up the datagrid to use a parameritised query that uses the selecteditem from my combo box. That works fine the problem I have is adding new rows. I want the list field to be set to the selected item in the combo box but have no idea on how to do it. I'm guessing I should be able to bind one of the properties in the combo box to the datasource field but don't know which one. |