How do I display records in a richtextbox?

[sanchezl]

Hi, I am developing a program in visual basic that extracts info from an access database.

So far I know how to add records, make a query and count the number of records that that query gives, but I don't know how to display the entire records that the query gives. Any idea?

So far I have: (it counts the number of records found, but I don't know how to display them)

con.ConnectionS tring = directory
con.Open()
ds.Clear()


sql = "select * from proyectos where mes='" & ComboBox6.Text & "' and año='" & TextBox1.Text & "';"
Dim dt As New DataTable
Dim o As New OleDb.OleDbData Adapter(sql, con)
o.Fill(dt)
MessageBox.Show (dt.Rows.Count)

[debasisdas]

if you want to display all the records simply use any grid control.