i want to search data from access database and display it in datagrid.
please help me..
thanks in advanced....:)
Sawamura
9
Junior Poster in Training
Recommended Answers
Jump to Postsee this code :
Dim sql As String Private Sub ViewData() Set rs = New ADODB.Recordset rs.CursorType = adOpenDynamic rs.LockType = adLockOptimistic rs.Open "SELECT * FROM Login Where UserID = '" & txtUserId.Text & "' AND Password = '" & txtPasw.Text & "'", Conn, , , adCmdText …
Jump to PostOk. this my connection code.
and don't forget to add the procedure name if you want to call every function that it has connection to database.Global Conn As ADODB.Connection Global rs As ADODB.Recordset Sub Access_Connector() Set Conn = New ADODB.Connection Conn.Provider = "microsoft.jet.oledb.4.0" Conn.CursorLocation = adUseClient …
All 5 Replies
Jx_Man
987
Nearly a Senior Poster
Featured Poster
Sawamura
commented:
awesome
+1
Jade_me
commented:
great
+1
Sawamura
9
Junior Poster in Training
Jx_Man
987
Nearly a Senior Poster
Featured Poster
Sawamura
9
Junior Poster in Training
Jx_Man
987
Nearly a Senior Poster
Featured Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.