Click here to Skip to main content
15,900,906 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralGone Backwards! :( Pin
Ray Cassick10-Nov-04 15:15
Ray Cassick10-Nov-04 15:15 
QuestionHow to show a form after closing it .. Pin
Modern_night10-Nov-04 13:56
Modern_night10-Nov-04 13:56 
AnswerRe: How to show a form after closing it .. Pin
Christian Graus10-Nov-04 14:25
protectorChristian Graus10-Nov-04 14:25 
GeneralRe: How to show a form after closing it .. Pin
Fade (Amit BS)10-Nov-04 15:49
Fade (Amit BS)10-Nov-04 15:49 
AnswerRe: How to show a form after closing it .. Pin
Steven Campbell11-Nov-04 6:48
Steven Campbell11-Nov-04 6:48 
GeneralRe: How to show a form after closing it .. Pin
Modern_night11-Nov-04 9:40
Modern_night11-Nov-04 9:40 
GeneralRe: How to show a form after closing it .. Pin
Steven Campbell11-Nov-04 14:48
Steven Campbell11-Nov-04 14:48 
GeneralRe: How to show a form after closing it .. Pin
Modern_night12-Nov-04 10:41
Modern_night12-Nov-04 10:41 
GeneralRe: How to show a form after closing it .. Pin
jamesbronw15-Nov-04 16:39
jamesbronw15-Nov-04 16:39 
QuestionMessenger users online/offline? Pin
[DK]KiloDunse10-Nov-04 13:10
[DK]KiloDunse10-Nov-04 13:10 
AnswerRe: Messenger users online/offline? Pin
Christian Graus10-Nov-04 13:23
protectorChristian Graus10-Nov-04 13:23 
GeneralRe: Messenger users online/offline? Pin
Anonymous10-Nov-04 13:27
Anonymous10-Nov-04 13:27 
GeneralRe: Messenger users online/offline? Pin
Christian Graus10-Nov-04 13:36
protectorChristian Graus10-Nov-04 13:36 
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 

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.