I have table-accessonbook and second table as report register
I want to fetch data from one table as name,age,sex with unique id
from 2nd table i want fetch Hb with same id
so that when i enter peticular id it should fetch data from both tables linked to that id.
i tried much but nothing found. pl help.
Satyam_1
0
Junior Poster
Recommended Answers
Jump to Postin a button click event create 2 different connection(oleDb.oleDbConnection) like this
Dim Connection1 As New OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;" & "Data Source='" & "Access 1 Full Path" & "';" & "Persist Security Info=False;" & "Jet OLEDB:Database Password=" & "your pass" & ";") Dim Connection2 As New OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;" & "Data Source='" …
Jump to PostDuplicate post: http://www.daniweb.com/software-development/vbnet/threads/476214/saving-selected-data-from-textbox-to-db
See your other post for a better database design. When you have a properly designed database, you can use "join" statements to retrieve the data you want.
All 5 Replies
oussama_1
39
Posting Whiz in Training
Satyam_1
0
Junior Poster
cgeier
187
Junior Poster
Satyam_1
0
Junior Poster
oussama_1
39
Posting Whiz in Training
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.