CodeCharge Studio
search Register Login  

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> .NET

 Using Checkbox List in a Grid

Print topic Send  topic

Author Message
Tim-TPM

Posts: 3
Posted: 03/02/2010, 4:30 AM

Hi,

I want to implement something similar to the the example "Many-to-Many Relations via CheckBox List", but the problem is that there was one Text field for the CheckBoxes (project name, in that example) and I want to display more information for each CheckBox option.

Can I combine a grid with the CheckBox List control, having CheckBoxes in each grid row that will insert/update a many-to-many relationship?

I would very much appreciate your help on how to do it.

(I'm using C#.NET)


Thanks in Advance
Tim
View profile  Send private message
Tim-TPM

Posts: 3
Posted: 03/03/2010, 11:55 PM

I tried simply placing a CheckBox List in a grid, it obviously didn't work and I got the warning message " For the Checkbox List only the first value is inserted or updated."

Any suggestions?

Regards
View profile  Send private message
dragoon


Posts: 173
Posted: 03/04/2010, 2:09 PM

You can archive this only using custom code;
Place it in After Execute Insert/Update/Delete

Still isn't too much having a checkbox list in an editable grid?
I'll rather make use of a grid and an editable grid / record.

Another thing, how your database structure looks like?
View profile  Send private message
Tim-TPM

Posts: 3
Posted: 03/05/2010, 10:25 PM

Thanks dragoon.

About the database structure: I'm trying to insert into a man-to-many table, with a composite PK (similar to the Order, OrderItem, Item design). One of the PK columns' value will come from another page (URL parameter), while the other value contributing in the PK will be inserted if the user selects a checkbox near the row of the item (which aggregates information from several tables using a view).

The user can choose many items, so many records can be inserted or updated.

I thought about the manual insert/update as you suggested, dragoon; but I'm not sure how the code will look like.
I'm thinking about adding a checkbox column to a non-editable grid, such that when the user clicks a submit button, the checkbox status is checked for each row, and if the checkbox is selected, the id value from that row is inserted into the many-to-many table.

I also want the checkboxes to reflect the rows in the database (in edit mode) by appropriately showing which checkboxes are selected and which are not.

I hope you didn't find my above explanation confusing.
I would very much appreciate your help regarding the checkbox properties (especially ControlSource and DataSource) the basic structure of the needed code (which functions will I need...etc.)

Kind regards

Tim
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.