How to loop data colum

[knockyo]

i want to take below data at "txnComment" that i highlight.

after i select the column, i just need the take the data that hv value

picture show below:

hope expert help me, thx

 

[cjard]

For Each dr as DataRow In DirectCast(myDataGrid.DataSource, DataTable).Rows
If dr("txnComment") IsNot Nothing Then ...

 

[knockyo]

sorry, i miss smth to 4get tell you all, that table is not a datagrid, tht is sql server database records..

Thx

 

[cjard]

SELECT txnComment FROM table WHERE txnComment IS NOT NULL

 

[knockyo]

i cannot using sql command to select the above txncomment, this is because the above data i already use stored procedure to generate. Eg:

select * from tblcomment where uniqueid='stored procedure (data above display)'

so i need use VB.net code to select the data of txncomment

 

[cjard]

select txnComment from tblcomment where uniqueid='stored procedure (data above display)' and txnCOmment IS NOT NULL