Click here to Skip to main content
16,023,224 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello,

Currently I have data in form of excel Please see the link for excel: http://docs.google.com/leaf?id=0B1wLQYEcS6KOZThiYjgyZDAtMmZlNC00ZWU0LTkyYTYtMTlhNmRiZDQ5ODY0&hl=en.
It is a relation between pattern and quality. If there is some type of relation then the respective cell is mapped. I need to push the data into DB and then display the data in same format as there in excel on web page.
My Approach:
Step 1) I created Mstpattern table with follwing column
intPat txtPatName txtOtherName txtContext
step 2) created MstQuality table
intQuality txtQAName txtQADefinition
step 3) Finally created realtional table with columns as
intPatQMatrixRel intMatrix intPat intQuality intRelation txtComment
I am facing problem in displaying the relation. First of all both the quality and pattern lists are not static and I have to display the relation as shown in excel. First cell in each row should be quality name and first cell in each column in pattern. How can I display it dynamically and map the relation between respective quality and pattern. Please help.
Thanks
Amit
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900