datagrid dropdownlist values
I've been successful at putting dropdownlists in a datagrid where the values come from a SQL stored procedure. And when I click edit, it displays the original value.
My problem comes when I added code to add a new record via the datagrid footer. Now the dropdownlists on the existing rows return more values than they should. e.g. it should give a choice of 1, 2, or 3. Instead I see 1, 2, 3, 1, 2, 3, 1, 2, or 3 when I click edit to an existing record. When I click the dropdownlist on a new record, that works fine.