Click here to Skip to main content
15,886,026 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Messenger users online/offline? Pin
[DK]KiloDunse10-Nov-04 13:41
[DK]KiloDunse10-Nov-04 13:41 
GeneralRe: Messenger users online/offline? Pin
Christian Graus10-Nov-04 13:54
protectorChristian Graus10-Nov-04 13:54 
GeneralRe: Messenger users online/offline? Pin
[DK]KiloDunse10-Nov-04 13:58
[DK]KiloDunse10-Nov-04 13:58 
AnswerRe: Messenger users online/offline? Pin
Ray Cassick10-Nov-04 15:16
Ray Cassick10-Nov-04 15:16 
GeneralRe: Messenger users online/offline? Pin
[DK]KiloDunse10-Nov-04 15:20
[DK]KiloDunse10-Nov-04 15:20 
GeneralRe: Messenger users online/offline? Pin
Fade (Amit BS)10-Nov-04 15:41
Fade (Amit BS)10-Nov-04 15:41 
GeneralRe: Messenger users online/offline? Pin
[DK]KiloDunse10-Nov-04 15:48
[DK]KiloDunse10-Nov-04 15:48 
Generalconnecting two datatables within a dataset and forming relation HELP Pin
cavall10-Nov-04 11:27
cavall10-Nov-04 11:27 
I have an access Table with vendor_num and vendor_name fields.
I have an oracle Table which has a vendor_num field and other fields of details.

Initially, my thought was to pull the access table into a dataset and then pull the oracle table into the dataset, form a datarelation between the two, and use GetChildRows to pull the other details from the oracle table I pulled in.

however...

When I tried to do this I got an error b/c not all data in the child table (oracle table) had a parent...

Can someone point me in the right direction into either fixing this train of thought or a new method altogether, please?

Thanks
Cavall

Dim conn As New OdbcConnection("Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\Documents and Settings\mwaters2\My Documents\VQM\testVQM.mdb;Uid=Admin;Pwd=;")
Dim da As New OdbcDataAdapter("SELECT Vendor_Num FROM Top50_test", conn)
Dim ds As New DataSet
da.Fill(ds, "Top50")
DataGrid1.DataSource = ds.Tables("Top50")
DataGrid1.DataBind()

Dim conn2 As New OleDbConnection("Provider=msdaora;Data Source=VQM;User Id=***;Password=***;")
Dim childSQL As String
childSQL = "" & _
"SELECT vendor.vendor_num, restratificationhistory.vend_accy " & _
"FROM vendor, restratificationhistory " & _
"WHERE vendor.vendor_num = restratificationhistory.vendor_num " & _
"AND restratificationhistory.dt_tm_added Between to_date('1/1/04','MM/DD/YY') AND to_date('11/10/04','MM/DD/YY')"
Dim da2 As New OleDbDataAdapter(childSQL, conn2)
da2.Fill(ds, "Details")

Dim parentCol As DataColumn = ds.Tables("Top50").Columns("Vendor_Num")
Dim childCol As DataColumn = ds.Tables("Details").Columns("Vendor_Num")
Dim dr As New DataRelation("VendorToDetails", parentCol, childCol)
ds.Relations.Add(dr)

"Nothing is at last sacred, but the integrity of your own mind."
"What lies behind us and what lies before us are nothing compared to what lies within us." - Ralph Waldo Emerson
Generalcrystal reports Pin
kixville10-Nov-04 9:48
kixville10-Nov-04 9:48 
GeneralCreate login form Pin
axing10-Nov-04 5:54
axing10-Nov-04 5:54 
GeneralRe: Create login form Pin
Mekong River10-Nov-04 17:01
Mekong River10-Nov-04 17:01 
GeneralTabControl Pin
Jeeva Jose10-Nov-04 5:38
Jeeva Jose10-Nov-04 5:38 
GeneralRe: TabControl Pin
Fade (Amit BS)10-Nov-04 15:59
Fade (Amit BS)10-Nov-04 15:59 
GeneralLoad Data Interchange File to dataset Pin
RDoes10-Nov-04 5:19
RDoes10-Nov-04 5:19 
GeneralBlank Message Box Pin
John Collis10-Nov-04 5:17
John Collis10-Nov-04 5:17 
GeneralRe: Blank Message Box Pin
Dave Kreskowiak10-Nov-04 9:04
mveDave Kreskowiak10-Nov-04 9:04 
GeneralRe: Blank Message Box Pin
John Collis10-Nov-04 21:19
John Collis10-Nov-04 21:19 
GeneralSort icon in listview (DotNet) Pin
SelvaRavi9-Nov-04 19:22
SelvaRavi9-Nov-04 19:22 
GeneralImport Data from Access to SQL Server Pin
Amitux9-Nov-04 18:39
Amitux9-Nov-04 18:39 
GeneralRe: Import Data from Access to SQL Server Pin
Dave Kreskowiak10-Nov-04 3:05
mveDave Kreskowiak10-Nov-04 3:05 
GeneralTAPI in VB.NET Pin
pht99999-Nov-04 14:56
pht99999-Nov-04 14:56 
GeneralRe: TAPI in VB.NET Pin
Dave Kreskowiak10-Nov-04 3:10
mveDave Kreskowiak10-Nov-04 3:10 
Generalsharing folder Pin
Paps29-Nov-04 14:18
Paps29-Nov-04 14:18 
GeneralRe: sharing folder Pin
Dave Kreskowiak10-Nov-04 3:03
mveDave Kreskowiak10-Nov-04 3:03 
GeneralRe: sharing folder Pin
Mekong River10-Nov-04 3:54
Mekong River10-Nov-04 3:54 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.