NosliwEkim
Nosliw
- Local time
- Today, 04:40
- Joined
- Jun 19, 2007
- Messages
- 2
Need general info on .Net ADO and Access in VS05
Hi,
First post in the forums for me and I have to say, this community seems to be one of the most helpful I've seen. I hope I'm in the right forum for these question, I'm generalizing some at first...
I'm 6 months new to C#, ADO coding and VS05 (Express still at this point), but not to worry the C# part, as I understand most here are VB.
My original DB was in MySql but due to the limitations of connection models in Express, I moved it to Access 2000 structure, to get a feel for the ADO and graphical concepts in VS05. So far it hasn't gone too badly, aside that the Access DB is behaving as "read only", if I try to reach it from OpenOffice and migration from MySql blew my PK/FK's and auto-numbers out the window. I was able to re-establish relations in VS no problem, however getting auto-num back for updates I'm still chasing.
I have succeeded in building the DataSet from Access in VS and was able to create the DataSet.xsd, establish relationships, build some integrated grids and see the simple linking relationships at work nicely.
Questions:
The point I'm at now, is learning how to manage the ADO data, (assuming ADO can now copy the Database local to the program as needed?) and figuring out how to make combined table-source queries, parameter queries and perhaps something like views to work in the forms I'm using.
(1) The first problem I saw was that with a zipcode file of 47,000 text entries, doing large forms with the full dataset takes forever. I keep a PK Auto-inc in the zipcode file which is surely indexed, but I'm wondering if and how I would add an index to the actual ascii zip code column in VS, or would I be better off compressing the ascii to binary and just use the PK index alone?
(2) Then, it seems like I should limit the zip code lookup to the data entry activities only and then make a temporary scratch table of the actual referenced and used zip codes that have been pulled up into the user's working set. That seems to me to blow the 3N theory a little but then again it's a temporary table used to keep the performance working right? Is this an acceptable approach and how would I do that in VS, to "Derive" a working sub list from the master set?
(3) Last, assuming I can create a crisp working set with a temporary, qualified, ZipCode scratch table, how does one go about creating parameterized queries in VS' visual designer of the dataset, so I can make combined-reference queries? For example I might want to join 3 related tables into one to use as my main indexing source in a primary/secondary form and then have the secondary appear as a grid from that first combined query. How do I create that master join set? Do I simply add query to the xsd graphic canvas and query builder the joins? If I "add query" to the regular data set tables to do this, it tells me my query does not match the original and refuses.
Well that's three roughly related questions which is enough for a thread so perhaps I can answer some specific replies that will help narrow down the approach, if some others would be willing to point me in the right direction.
Thanks in advance,
Nosliw
Hi,
First post in the forums for me and I have to say, this community seems to be one of the most helpful I've seen. I hope I'm in the right forum for these question, I'm generalizing some at first...
I'm 6 months new to C#, ADO coding and VS05 (Express still at this point), but not to worry the C# part, as I understand most here are VB.
My original DB was in MySql but due to the limitations of connection models in Express, I moved it to Access 2000 structure, to get a feel for the ADO and graphical concepts in VS05. So far it hasn't gone too badly, aside that the Access DB is behaving as "read only", if I try to reach it from OpenOffice and migration from MySql blew my PK/FK's and auto-numbers out the window. I was able to re-establish relations in VS no problem, however getting auto-num back for updates I'm still chasing.
I have succeeded in building the DataSet from Access in VS and was able to create the DataSet.xsd, establish relationships, build some integrated grids and see the simple linking relationships at work nicely.
Questions:
The point I'm at now, is learning how to manage the ADO data, (assuming ADO can now copy the Database local to the program as needed?) and figuring out how to make combined table-source queries, parameter queries and perhaps something like views to work in the forms I'm using.
(1) The first problem I saw was that with a zipcode file of 47,000 text entries, doing large forms with the full dataset takes forever. I keep a PK Auto-inc in the zipcode file which is surely indexed, but I'm wondering if and how I would add an index to the actual ascii zip code column in VS, or would I be better off compressing the ascii to binary and just use the PK index alone?
(2) Then, it seems like I should limit the zip code lookup to the data entry activities only and then make a temporary scratch table of the actual referenced and used zip codes that have been pulled up into the user's working set. That seems to me to blow the 3N theory a little but then again it's a temporary table used to keep the performance working right? Is this an acceptable approach and how would I do that in VS, to "Derive" a working sub list from the master set?
(3) Last, assuming I can create a crisp working set with a temporary, qualified, ZipCode scratch table, how does one go about creating parameterized queries in VS' visual designer of the dataset, so I can make combined-reference queries? For example I might want to join 3 related tables into one to use as my main indexing source in a primary/secondary form and then have the secondary appear as a grid from that first combined query. How do I create that master join set? Do I simply add query to the xsd graphic canvas and query builder the joins? If I "add query" to the regular data set tables to do this, it tells me my query does not match the original and refuses.
Well that's three roughly related questions which is enough for a thread so perhaps I can answer some specific replies that will help narrow down the approach, if some others would be willing to point me in the right direction.
Thanks in advance,
Nosliw
Last edited:
Maybe some kind soul will help me through all the confusion anyhow. Thanks for the "Heads up".
