动态复选框列表 [英] dynamic checkbox list

问题描述

你好，

我正在用C#开发一个项目，在该项目中我希望输出类似以下的内容.


类别1
子类别1
Sub_Subcategory1 Sub_Subcategory2

子类别2
Sub_Subcategory1 Sub_Subcategory2


类别2
类别3

所有这些都必须使用动态复选框列表从数据库中填充，
当我选择Sub_Subcategories时，必须将其输入数据库.
如果我选中必须显示Category1，Subcategory1和Subcategory2，如果我选中必须显示Subcategory1，Sub_Subcategory1和Sub_Subcategory2.

请帮帮我.

由于正在使用更新面板，因此无法使用treeview控件.

Hello,

I am developing a project in c# in which i want the output some thing like this.


Category1
Subcategory1
Sub_Subcategory1 Sub_Subcategory2

Subcategory2
Sub_Subcategory1 Sub_Subcategory2


Category2
Category3

All this has to be populated from database by using dynamic checkboxlist,
when i select Sub_Subcategories it has to be entered into the database.
if i check Category1,Subcategory1 and Subcategory2 has to displayed, if I check Subcategory1, Sub_Subcategory1 and Sub_Subcategory2 has to be displayed.

Please help me.

since am using update panel am unable to use the treeview control. can any one help me to come out this asap.

推荐答案

没有足够的信息...
假设SQL表是:
类别
int id; (主键)
varchar cat;

子类别
int subid;
int catid; (外键)
varchar subcat;

假设您有SQLConnectionString:
您应该具有在表中获取和设置行的类.
对于类别，您需要像
这样的SQL方法 ''从类别中选择*，其中id = ???''
对于子类别:
``从SubCategory中选择* where catid = ???''

我不知道您所说的动态复选框"是什么意思
但应该有一个类似这样的事件:
void CheckboxChanged或SelectedIndex

在此事件处理程序中
如果(选中此复选框，则获取类别ID或子类别ID
使用类别类的选择，插入或更新方法

there''s not enough information...
assuming the SQL tables are:
Category
int id; (primary key)
varchar cat;

Subcategory
int subid;
int catid; (foreign key)
varchar subcat;

Assuming you have your SQLConnectionString:
You should have classes that get and set rows in the tables.
for Category you need SQL methods like
''select * from Category where id = ???''
for sub categories:
''select * from SubCategory where catid=???''

I don''t know what you mean by ''dynamic checkbox''
but there should be an event like:
void CheckboxChanged or SelectedIndex

in this event handler
if(checkbox is checked) get category id or sub-categoryid
use Category class select, insert or update method

这篇关于动态复选框列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！