how to display records from ms access to vb.net in tablat format using adodb VB.NET: MS-Access Interaction Tutorial (Part I)

[iGuest 3]

how to display records from ms access to vb.net in tablat format using adodbVB.NET: MS-Access Interaction Tutorial (Part I)

hi

I am doing a project in vb.Net using ms access as database

but I am unable to display data from access to vb in table form

I am receiving data from aceess using msgbox

actually I don't know any function to display data in table

so Please anybody can help me to solve this

my code is as below 

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e AsHandles Button1.Click System.EventArgs)

Dim s As String = Trim(InputBox("Enter Company_ID"))

Dim Temp_rs As New ADODB.Recordset

strconnect = "select * from Company_Master where Company_ID like '%""%' order by Company_ID" + s +

Temp_rs.Open(strconnect, adocon, CursorTypeEnum.AdOpenDynamic, LockTypeEnum.AdLockOptimistic)

Temp_rs.Find("Company_ID=" & s)

MsgBox("Company_ID=" & Temp_rs.Fields("Company_ID").Value & " Company_name=" & Temp_rs.Fields("Company_Name").Value)

End Sub

thank you for your  help in advance

 

-question by mrudula