Show Data in matrix form with checkboxes

I am not sure how to attack this one.  Lets start with the tables that I want my GridView to be based on:

Customer_graph (table)
-------------------
CustomerGraphID
CustomerID
GraphID

 
Graph (table)
-------
GraphID
GraphName

 
Ultimately what I am trying to create is this (this is a sketch of mine):

http://www.webfound.net/graph_grid.jpg
Note that in the pic, the graph column names would be the GraphName from the Graph Table

The user should be able to check off which customers should be included for which graphs.  I’m not sure how to dynamically create this inside a GridView with a checkboxlist and then how to grab what was selected and insert into the final table below.

I’ll definitely need a 3rd table to record the results...what was checked, something like:

Customer_Graph_Selected (final table)
------------------------------
CustomerID
GraphID


For starters, I have a GridView I have used in another app of mine:

http://www.webfound.net/past_gridview.txt
LVL 1
dba123Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

GavinMannionCommented:
I would actually do this in SQL

I just tried to write the query and got confused. Rather post a pointer question in the SQL TA to get the stored procedure created.

Once you have the data then just bind to a GridView as normal and update depending on the checkboxes ticked.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dba123Author Commented:
I need to know how to create the grid...How do I get the grid to look like that and add the checkboxlists like this in the order I show on the screenshot?
0
dba123Author Commented:
so I don't need to worry about how each checkbox will figure out what field to update in the table?  If a user clicks checkbox 40 for example, how does it know to create a new record in my final table based on the entire row where that checkbox is checked?
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

dba123Author Commented:
So what I need to know is

1) How to create the GridView with checkbox list in relation to my table setup and desired screen shot
2) How does the grid add rows to a third table based on what was selected.  For example, lets say for CompanyA I checked boxes 2 and 3 in that row.  I want to insert this row into a third table because at least one of the checkboxes were checked.  Later on, I can then use this table in other queries for other purposes to filter out stuff based on what the user selected
3) How do I do all this period?  I don't see how the checkboxes can be created dynamically based off my tables and then how I can insert those rows from the grid that the user has selected something on into a third table!
0
dba123Author Commented:
I need hand holding for the entire grid for my first time here.
0
dba123Author Commented:
let me work on the SQL...brb
0
dba123Author Commented:
wait...I'm overthinking this.  I think I'm all set now...sorry.  I'm gonna PAQ based on SQL but now that I think about it, this isn't classic ASP anymore and I don't need to worry about so many complexities this time :)
0
GavinMannionCommented:
Wow, worry for missing all the comments I was sleeping :)

Thanks for the points but I don't think I answered your question? Did I?

0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP.NET

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.