dynamic row and column from DB

Question

5.00/5 (1 vote)

See more:

Hello,

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.

Thanks
Amit

Posted 10-May-10 5:46am

Member 4384856

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Christian Graus · Answer 1 · 2010-05-10T12:30:00

Solution 1

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 ?

Posted 10-May-10 12:30pm

Christian Graus

Comments

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: 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 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.

Regards,
Amit