How to retrive data from table? - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

How to retrive data from table?

paulvbpaulvb Posts: 42Member
In my table i have a row called barcode. I need to find barcode 456456, and display the rows information in a Textbox?

Can anyone help, just a beginner.

Comments

  • PavlinIIPavlinII Posts: 404Member
    : In my table i have a row called barcode. I need to find barcode 456456, and display the rows information in a Textbox?
    :
    : Can anyone help, just a beginner.
    :
    Hi,
    I guess you have table with several rows and there exist column "BarCode" in your table.

    [code]For Each r As DataRow In MyTable.Rows
    txtBarCodes.Text &= CStr(r("BarCode")) & vbNewLine
    Next[/code]

    Loop throught each Row in Rows of table, get value of r("BarCode"), convert it to string by CStr - CStr(r("BarCode")) and add new line separator (set txtBarCodes.MultiLine=True)

    Hope this helps

    [blue][b][italic][size=4]P[/size]avlin [size=4]II[/italic][/size][/b][/blue]

    [purple]Don't take life too seriously anyway you won't escape alive from it![/purple]


Sign In or Register to comment.