create dynamic datagrid and saving user preference

Question

0.00/5 (No votes)

See more:

            Status_1	Status_2	Status_3	Status_4	Status_5	Status_6
Status_1								
Status_2							
Status_3						
Status_4									
Status_5						
Status_6						

i want to create a dynamic datagrid as above. All status are in table in my database.
Status value will be my column in datagrid and first column of the grid as above.
Checkbox will appear on each cell of grid where user can check/uncheck value
and save in database.

can anyone help me how to design my datagrid. Thanks in advance.

Posted 3-Apr-13 22:09pm

Member 3884193

Updated 4-Apr-13 19:45pm

v3

Add a Solution

Comments

Maciej Los 4-Apr-13 8:20am

What have you done till now?

Chinmaya C 5-Apr-13 4:05am

As per my understanding, you need to create DataSource dynamically based on your requirement and bind that to the grid.

V. 5-Apr-13 4:10am

What did you do? If you're stuck with a big problem, try breaking it down into smaller problems:
1: Can you build a grid from code? Create a prototype solution and start with hardcoded values, then strip as much as you can to dynamic values
2: Can you read data from a database? Can you write to it? Create a prototype solution and start with selecting, updating and deleting values.
3: before jumping to merging 1 and 2. THINK. What does it need to do and what will it need to do next year, the year after that? What data needs to be in the database, what types and how will I structure it ? From the database design start coding the access to it (step 2). Once you have the data, create a "grid builder" that handles the translation from objects to a grid (step 1). Then go backward again: grid to object to database.

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)