Cor:
Don't judge Americans based on my frustrations. Also, Nationalism has
nothing to do with this issue.
People from all countries get frustrated at some point.
You can imagine my frustration when my friend asked me "Why are you using
untyped datasets Mr. MS Access Boy?" after I had done all that work.
Simply go with typed datasets in designer using the wizerds and create the
relations in the Schema and you will see your joined tables when you drill
down below the parent table. There you can select your fields for your
controles and you can have your MS Access scenario fun.
I had originaly tried this and it would work ok. Just sometimes the wizard
would not set the source column for the Original_CulumnName for any of the
fields.
No matter how many times I tried to regenerate the DataAdapter, it would not
work. The more I repeated the steps, the more it started making other
problems.
So again, after I spoke with my friend, I would run into the same problem.
That is what let me to the question VB.NET vs C#
So, I called him. He told me I was crazy until he was able to recreate the
problem. his response was that it's probably a bug. Simply create the
DataAdapters only 2 or 3 at a time, place my controles, bind my controles.
Save my project, test it and back it up often.
I was trying to create all 26 DataAdapters, Generate DataSet, Create
Relations, Save my project. Seems VB.NET can't handle that scenario.
Simply creating a few DataAdapters at a time, binding the controles, Saving,
Closing VS, Reopening, continuing seems to be working.
It's not my hardware (P4 3.0 Ghz, 80 GIG ATA 133, 1 GIG DDR 400)
Fortunatly, I was able to copy and paste all my controles from the first
project that has the untyped Dataset so I didn't have go through the boring
task of recreating all of them, lining them up etc ...
So, after all that, I decided to import the tables to SQL Server and use the
SQL DataAdapter wizards to generate Stored Procedures which seems nice so
far. Sometimes it still acts up and decides to automaticly create a second
sqlconnection and not create the proper field mapping which I find strange
but who kows what gets stuck in memory. So far, I have 16 backups of my
project.
Have a nice weekend
Bob