how to retreive a column from a datagrid?

sunspotzzz

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

sunspotzzz22y ago
Hi, thanks a lot for your reply. It is working!
0
Andrzej Wegierski22y ago
There're some methods: int row,column; from DataGrid: myDataGrid[row,column].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 ....
0