how to retreive a column from a datagrid?

Question

Hi I input query codes into a table in SQL server 2000 and used a datagrid1 to display the query code. However now I need to execute the query code and pass it into datagrid2. How can I execute it? Can I get the string in the datagrid1 and execute it using sqlcommand. thanks

sunspotzzz · Answer

Hi thanks a lot for your reply. It is working!

Andrzej Wegierski · Answer

There're some methods: int rowcolumn; from DataGrid: myDataGrid[rowcolumn].ToString() from DataSource of DataGrid: myDataTable.Rows[row][column].ToString() -or- myDataTable.Rows[row][columnname].ToString() row in DataSource not equals row in DataGrid (depends on sorting) from DataView used by DataGrid myDataTable.DefaultView[row][column].ToString() -or- myDataTable.DefaultView[row][columnname].ToString() from internal DataView used by DataGrid use protected property ListManager.List in inherited control ....