How do I....

[Buaya_hunter]

How do I display the data I retrive from a microsoft access database into a textbox in VB.NET?

[brown monkey]

something like this

Dim cn As New OleDbConnection()
    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        cn.ConnectionString = "provider=microsoft.jet.oledb.4.0;data source=d:/northwind.mdb"
        cn.Open()
        Dim cm As New OleDbCommand("select companyname from customers where customerid='alfki'", cn)
        TextBox1.Text = CType(cm.ExecuteScalar, String)
        cn.Close()
    End Sub

[Buaya_hunter]

Thanks a lot. I tried seatching on the net but a lot of example are meant for web based development, not desktop application

[taxes]

Originally posted by Buaya_hunter
Thanks a lot. I tried seatching on the net but a lot of example are meant for web based development, not desktop application

Did it work?

[Buaya_hunter]

It works very well for my purpose

[taxes]

Hi,

The reason why I asked was that I had to use

Dim cn As New Oledb.OleDbConnection()

Dim cm As New Oledb.OledbCommand

[brown monkey]

imports system.data.oledb

[taxes]

Originally posted by brown monkey
imports system.data.oledb

Thank you