My DB table has a field "staus" which holds any of the 3 value a)requested, b)pending, c)confirmed. i display the data of this table in a gridview using taableadapter& typed datatable. (My table adapter dataset is for a single table only). When i load data from database to grid, it should show the "status" field with the value in DB with other 2 option. again I want to display this in a combo in my grid with the DB value for "status" field selected...i.e. status field in grid should have all 3 option displayed with the value in DB having default select.
Also as my target is to have minimum DB access, i cannot include queries to hit DB... any code that hits my dataset is fine....
Can anyone suggest on some option to achieve this....
Thanks in advance
Nishitha