dataset MultiDimensional

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...
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
Click to expand...
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!!!!
 
Back
Top