Hi, I have a web form. I am using sql dataadapter, dataset and datagrid for displaying the data. (C#) In first column of all the rows, I have dropdown list that I want to populate on the fly. (so, number of dropdown lists = number of rows) Some of the options in the drop down list are common (e.g.: "View the Order", "Open the Order", "Print the Order" etc.) where as some of the options are specific to the Order Number (e.g.: "Order ######" etc.). Order # is the next column in the datagrid. So, I want to basically capture this Order # and put it as an available option in the dropdown list of the current row. (there is a unique Order # for every row and that # must be the option in the drop down list). How do we do this?

I have written common options in the html section, but I need the Order # which are generated on the fly based on the main SQL statement.











View Order
Print Order
Copy Order
============








<%#DataBinder.Eval(Container.DataItem, "OSP_CustomerPO") + "/" + DataBinder.Eval(Container.DataItem, "OSP_CustomerStk")%>





<%#DataBinder.Eval(Container.DataItem, "ORD_StatusUSASales") + "/" + DataBinder.Eval(Container.DataItem, "ORD_StatusUSAOPD")%>