I have a dataset that the user has changed in a Datagrid. I want to take one column of data, i.e. sales order # and get an array so I can use the list in another SQL lookup for more details on the order number.
ord_no Cust_no Address
1 3334 1 Test Dr.
2 3336 5 Test Dr.
6 3339 9 Test Dr.
Now I need to get the ord_no from the dataset as the following
(1, 2, 6)
Reason is so I can place into SQL command Select * from Order_details where ord_no in (1, 2, 6)