To solve a data sheet is submitted to the code design, database

A two-dimensional table, 9 row, 9 column, to realize the online submission form. Save to SQL2008 function.. For the code design, the other to ask this two-dimensional tables, database structure design, is designed to the child table, or a content storage.. Acute. . .

Started by Lisa at November 08, 2016 - 10:01 AM

Depends on how do you intend to use these data.

If need longitudinal query (search for a line of a column of data records), then each cell separately maintained relatively good, or a comma delimited or XML stored in a field can be.
If the row column numbers is 81, and high performance requirements, can do 81 fields.
If the performance requirements is not high, can each row store your for a row of data table, and the additional line number field.
If the ranks are uncertain, is the use of sparse storage, also is the line number, column number, value of the stored.

Posted by Gladys at November 11, 2016 - 10:04 AM

The nine row and the nine column is what? The chess board?

Only nine rows and nine columns, and asked them how to design tables.

You can't hit a few more words?

Posted by Noah at November 22, 2016 - 10:51 AM

Primary key, ID, line number, column number, content, when the query trouble spots, each line should be spelled with left join

Posted by Omar at December 05, 2016 - 11:25 AM

Thinking about excel structure.
Row number, column number, value, type.
Although such performances are relatively poor, but can meet your needs.

Posted by Betty at December 20, 2016 - 11:44 AM