你好, 我正在用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
更多推荐
动态复选框列表
发布评论