Click here to Skip to main content
15,312,347 members
Please Sign up or sign in to vote.
5.00/5 (1 vote)
See more:

I have relation between quality and pattern in excel. Horizontal columns line represents various qualities and vertical patterns. The relationship is many to many. I need to push the excel into DB and then fetch the data using C#. Please suggest whether it will be possible using datagrid. Problem here is both the rows and columns are not fixed. And the logic to find the relation between the quality and pattern.


1 solution

A datagrid will show one table of data, which can be the result of any SQL query. A master/detail view can be created with two grids, which may be what you want. the rest of your question makes no sense, how can we tell you to traverse your data without knowing the schema and your requirements ?
Member 4384856 10-May-10 20:53pm
Hi Christian,
Thanks a lot for replying. I was trying to attach the excel sheet for displaying schema but could not do so.
Currently I have data in form of excel Please see the link for excel:
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 created Mstpattern table with follwing columnn
intPat txtPatName txtOtherName txtContext
MstQuality table
intQuality txtQAName txtQADefinition
Finally 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.


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