get the value of the data in a column in oledbconnection

[meenakshikalera]

hi!

i have created a dataset using the oledbconnection...not a datagrid though...i want the value of the data in a particular column in the dataset.

how do i do this?
thanks,
regards,
meenakshi

 

[andrea96]

You can go through each row and set a variable to the item value like this.

For i As Integer = 0 To ds.Tables(0).Rows.Count - 1
    Dim myRow As DataRow = ds.Tables(0).Rows(i)
    Dim s As String = myRow.Item("column").ToString 
Next

Is this what you are looking for?

Andrea

 

[meenakshikalera]

hi andrea!

thank u...looks fine...i am integrating this logic into my code...i tested a part of it ...looks fine...i hope i can use it for the actual thing that i want...join etc.
i will get back to u if i have any other doubt regarding this on monday...

thanks a lot!

regards,
meenakshi