By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,649 Members | 696 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,649 IT Pros & Developers. It's quick & easy.

dataset MultiDimensional

P: n/a
This is a little complex of a questions

I have a table, in a windows form that a user fills out and then gets stored into SQL, and when the user comes back the info is filled back into the table. So basically its a three dimensional situation. I need to store a table into SQL and I would like each row in SQL to be a table that a user fills out, but this makes it complex for data analysis(and I don't know how to create 3d tables) Is there are better solution?? Each table does have a uniques ID number, but I've noticed that SQL/Access will sometimes re-order the rows as I put them in, so when I pull them out, they are not in the rows are not in the same order. I could create row index, to reorder the rows, but that just seems like adding more data. Any ideas, besides creating a row index

Second Part of this whole scenario.... Need for Speed, what is the fastest access method to SQL via .net? I'm using the SQLClient namespace, but I wasn't sure if there was something faster. I have to read from a Hexadecimal file based database system, so any speed I can get on the SQL side helps!!!

Thanks

D_G
Jul 21 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Cor
Hi Dave,

The answer is very simple, there is not any field in any SQL based database
system that can fit a table.

Therefore you can only work with tables who have childtables.

A quiet normal solution in SQL I thought,

But primarly this is a SQL question, so if you want help from someone in a
newsgroup, I would ask it in a SQL newsgroup.

I hope this helps a little bit?

Cor
This is a little complex of a questions.

I have a table, in a windows form that a user fills out and then gets stored into SQL, and when the user comes back the info is filled back into
the table. So basically its a three dimensional situation. I need to store
a table into SQL and I would like each row in SQL to be a table that a user
fills out, but this makes it complex for data analysis(and I don't know how
to create 3d tables) Is there are better solution?? Each table does have
a uniques ID number, but I've noticed that SQL/Access will sometimes
re-order the rows as I put them in, so when I pull them out, they are not in
the rows are not in the same order. I could create row index, to reorder
the rows, but that just seems like adding more data. Any ideas, besides
creating a row index?
Second Part of this whole scenario.... Need for Speed, what is the fastest access method to SQL via .net? I'm using the SQLClient namespace,
but I wasn't sure if there was something faster. I have to read from a
Hexadecimal file based database system, so any speed I can get on the SQL
side helps!!!!
Thanks!

D_G

Jul 21 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.