I am trying to display data from access base.
this is what i have so far.
VB Code:
Dim MyConn As ADODB.Connection Dim MyRecSet As ADODB.Recordset Dim strName As String Dim strAddress As String Dim strPhone As String Private Sub Form_Load() MyRecSet.CursorLocation = adUseClient MyConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "/" & "database.mdb;" MyConn.Open Set MyRecSet = MyConn.Execute("SELECT * FROM Patients") End Sub
i want the stuff to display in flexgrid or datagrid.
how do i go about doing that?




Reply With Quote