返回首页

假设我们有10复选框THN 5 selected.i想,的5 chechbox在字符串文本由分离店(,)THN字符串传递给sqlquery的insertiojn数据库中.....请帮我........ 。thanx

回答

评论会员:游客 时间:2012/02/06
Muralikrishna8811:嗨,这里我想为您requirement.try一些代码,这一次...codeprelang="HTML"spanclass="code-keyword"</spanspanclass="code-leadattribute"asp:checkboxlist/spanspanclass="code-attribute"id/spanspanclass="code-keyword"="/spanspanclass="code-keyword"CheckBoxList1"/spanspanclass="code-attribute"runat/spanspanclass="code-keyword"="/spanspanclass="code-keyword"server"/spanspanclass="code-attribute"xmlns:asp/spanspanclass="code-keyword"="/spanspanclass="code-keyword"#unknown"/spanspanclass="code-attribute"/spanspanclass="code-attribute"<asp:listitem/spanspanclass="code-attribute"text/spanspanclass="code-keyword"="/spanspanclass="code-keyword"checkbox1"/spanspanclass="code-attribute"value/spanspanclass="code-keyword"="/spanspanclass="code-keyword"checkbox1"/spanspanclass="code-attribute"/spanspanclass="code-keyword"<//spanspanclass="code-leadattribute"asp:listitem/spanspanclass="code-attribute"<asp:listitem/spanspanclass="code-attribute"text/span=spanclass="code-keyword""/spanspanclass="code-keyword"checkbox2"/spanspanclass="code-attribute"value/span=spanclass="code-keyword""/spanspanclass="code-keyword"checkbox2"/spanspanclass="code-attribute"</spanspanclass="code-keyword"//spanspanclass="code-attribute"asp:listitem/spanspanclass="code-attribute"<asp:listitem/spanspanclass="code-attribute"text/span=spanclass="code-keyword""/spanspanclass="code-keyword"checkbox3"/spanspanclass="code-attribute"value/span=spanclass="code-keyword""/spanspanclass="code-keyword"checkbox3"/spanspanclass="code-attribute"</spanspanclass="code-keyword"//spanspanclass="code-attribute"asp:listitem/spanspanclass="code-attribute"<asp:listitem/spanspanclass="code-attribute"text/span=spanclass="code-keyword""/spanspanclass="code-keyword"checkbox4"/spanspanclass="code-attribute"value/span=spanclass="code-keyword""/spanspanclass="code-keyword"checkbox4"/spanspanclass="code-attribute"</spanspanclass="code-keyword"//spanspanclass="code-attribute"asp:listitem/spanspanclass="code-attribute"<asp:listitem/spanspanclass="code-attribute"text/span=spanclass="code-keyword""/spanspanclass="code-keyword"checkbox5"/spanspanclass="code-attribute"value/span=spanclass="code-keyword""/spanspanclass="code-keyword"checkbox5"/spanspanclass="code-attribute"</spanspanclass="code-keyword"//spanspanclass="code-attribute"asp:listitem/spanspanclass="code-attribute"<asp:listitem/spanspanclass="code-attribute"text/span=spanclass="code-keyword""/spanspanclass="code-keyword"checkbox6"/spanspanclass="code-attribute"value/span=spanclass="code-keyword""/spanspanclass="code-keyword"checkbox6"/spanspanclass="code-attribute"</spanspanclass="code-keyword"//spanspanclass="code-attribute"asp:listitem/spanspanclass="code-attribute"<asp:listitem/spanspanclass="code-attribute"text/span=spanclass="code-keyword""/spanspanclass="code-keyword"checkbox7"/spanspanclass="code-attribute"value/span=spanclass="code-keyword""/spanspanclass="code-keyword"checkbox7"/spanspanclass="code-attribute"</spanspanclass="code-keyword"//spanspanclass="code-attribute"asp:listitem/spanspanclass="code-attribute"<asp:listitem/spanspanclass="code-attribute"text/span=spanclass="code-keyword""/spanspanclass="code-keyword"checkbox8"/spanspanclass="code-attribute"value/span=spanclass="code-keyword""/spanspanclass="code-keyword"checkbox8"/spanspanclass="code-attribute"</spanspanclass="code-keyword"//spanspanclass="code-attribute"asp:listitem/spanspanclass="code-attribute"<asp:listitem/spanspanclass="code-attribute"text/span=spanclass="code-keyword""/spanspanclass="code-keyword"checkbox9"/spanspanclass="code-attribute"value/span=spanclass="code-keyword""/spanspanclass="code-keyword"checkbox9"/spanspanclass="code-attribute"</spanspanclass="code-keyword"//spanspanclass="code-attribute"asp:listitem/spanspanclass="code-attribute"<asp:listitem/spanspanclass="code-attribute"text/span=spanclass="code-keyword""/spanspanclass="code-keyword"checkbox10"/spanspanclass="code-attribute"value/span=spanclass="code-keyword""/spanspanclass="code-keyword"checkbox10"/spanspanclass="code-attribute"</spanspanclass="code-keyword"//spanspanclass="code-attribute"asp:listitem/spanspanclass="code-attribute"</spanspanclass="code-keyword"//spanspanclass="code-attribute"asp:checkboxlist<br/spanspanclass="code-keyword"//spanspanclass="code-attribute"/spanspanclass="code-attribute"<asp:button/spanspanclass="code-attribute"id/span=spanclass="code-keyword""/spanspanclass="code-keyword"Button2"/spanspanclass="code-attribute"runat/span=spanclass="code-keyword""/spanspanclass="code-keyword"server"/spanspanclass="code-attribute"text/span=spanclass="code-keyword""/spanspanclass="code-keyword"submit"/spanspanclass="code-attribute"onclick/span=spanclass="code-keyword""/spanspanclass="code-keyword"Button2_Click"/spanspanclass="code-attribute"xmlns:asp/span=spanclass="code-keyword""/spanspanclass="code-keyword"#unknown"/spanspanclass="code-keyword"//spanspanclass="code-attribute"<br/spanspanclass="code-keyword"//spanspanclass="code-attribute"/spanspanclass="code-attribute"<div/spanspanclass="code-attribute"id/span=spanclass="code-keyword""/spanspanclass="code-keyword"resdiv"/spanspanclass="code-attribute"runat/span=spanclass="code-keyword""/spanspanclass="code-keyword"server"/spanspanclass="code-attribute"</spanspanclass="code-keyword"//spanspanclass="code-attribute"div/span/pre/code和代码隐藏文件中包含下面的代码{C}在这里,你可以使用str变量来存储到数据库中。我希望你知道如何存储在数据库中该值所有最好的
SAKryukov
评论会员:游客 时间:2012/02/06
非常糟糕的主意。不保存用户界面。有一个单独的数据层和数据绑定的UI。不保存一些字符串,保存逻辑数据。特别是,102个状态复选框映射到10位位组,这是最好的16位整数(数据库类型"的SMALLINT"),一位代表,每复选框,6位仍然闲置。如果复选框组的每一位独立的语义感,创建一个由枚举类型与语义的名称为每个成员代表一个位set映射。在C#中,它会看起来像这样:codeprelang="cs"spanclass="code-keyword"enum/spanOptionSet:System.spanclass="code-SDKkeyword"Int16/span{None=spanclass="code-digit"0/span,CaseSensitive=spanclass="code-digit"1/span<<spanclass="code-digit"0/span,spanclass="code-comment"///spanspanclass="code-comment"1/spanBackward=spanclass="code-digit"1/span<<spanclass="code-digit"1/span,spanclass="code-comment"///spanspanclass="code-comment"2/spanUseRegEx=spanclass="code-digit"1/span<<spanclass="code-digit"2/span,spanclass="code-comment"///spanspanclass="code-comment"4/spanSelection=spanclass="code-digit"1/span<<spanclass="code-digit"3/span,spanclass="code-comment"///spanspanclass="code-comment"8/spanspanclass="code-comment"///spanspanclass="code-comment".../span}/pre/code这件事储存在铸造的SMALLINT,类型的情况下,它的语义操作(业务逻辑),地图复选框位位设置,使用周期和位操作回OptionSetdababase类型。我相信你知道如何设置,清除和测试bithellip;mdash;SA