Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Show Data in matrix form with checkboxes

Posted on 2006-04-19
8
Medium Priority
?
548 Views
Last Modified: 2008-02-01
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
0
Comment
Question by:dba123
  • 6
  • 2
8 Comments
 
LVL 15

Accepted Solution

by:
GavinMannion earned 2000 total points
ID: 16487375
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
 
LVL 1

Author Comment

by:dba123
ID: 16488281
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
 
LVL 1

Author Comment

by:dba123
ID: 16488297
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 1

Author Comment

by:dba123
ID: 16488333
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
 
LVL 1

Author Comment

by:dba123
ID: 16488340
I need hand holding for the entire grid for my first time here.
0
 
LVL 1

Author Comment

by:dba123
ID: 16488413
let me work on the SQL...brb
0
 
LVL 1

Author Comment

by:dba123
ID: 16494104
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
 
LVL 15

Expert Comment

by:GavinMannion
ID: 16495451
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In an ASP.NET application, I faced some technical problems. In this article, I list them out and show the solutions that I found.  I hope it will be useful. Problem: After closing a pop-up window, the parent page should be refreshed automaticall…
IntroductionWhile developing web applications, a single page might contain many regions and each region might contain many number of controls with the capability to perform  postback. Many times you might need to perform some action on an ASP.NET po…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question