If I have a datagridview that is bound to a dataset which comes from a MSSQL database, how can I have the datagridview display only one row of data from the dataset rather than all of the rows?
Specifically, the first column is a combobox which is bound to the items in the dataset. When the datagridview loads, it displays as many rows as there are items in the dataset. I need to display only one row, allow the user to select an item from the combobox and enter through the rest of the columns in the row, and then add another row after that.

3 Years
Discussion Span
Last Post by ddanbe

Don't bounds the combobox to the dataset. by a loop read the table and add the value of the datafield to the combobox at the time of loading of the form. Then add a row->choose item from combobox and go through the other cells. No need to load data everytime when you have been added a new row.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.