问题描述
我有一个表Table1,其中有4个字段TView,TRead,TUpdate,TDelete整数类型.
这些字段存储1或o.
I Have one table Table1 which have 4 field TView,TRead,TUpdate,TDelete integer type.
these field store 1 or o .
<asp:CheckBoxList ID="chkEmplyeeMaster" runat="server"
RepeatDirection="Horizontal" CssClass="chkclass">
<asp:ListItem Value="1">View</asp:ListItem>
<asp:ListItem Value="2">Read</asp:ListItem>
<asp:ListItem Value="3">Update</asp:ListItem>
<asp:ListItem Value="4">Delete</asp:ListItem>
</asp:CheckBoxList>
当任何一个chekbox都被咀嚼时,则将其存储在Sql表中1.
现在我在以上"列中的所有值均为1,我需要编辑checkboxlist值.
我如何从这4个字段值填充chekboxlist,当值为1时检查,否则在0值处显示取消选中.
请帮助我......................................
感谢
when any chekbox cheked then its store 1 in Sql table.
Now I have these Above column all value is 1 i need to edit checkboxlist value .
how can i populate chekboxlist from these 4 field value ,when value is 1 then checked otherwise at 0 value its show uncheck.
please help me .......................
thanks
推荐答案
<asp:CheckBoxList ID="chkEmplyeeMaster" runat="server"
RepeatDirection="Horizontal" CssClass="chkclass">
<asp:ListItem Text="View"></asp:ListItem>
<asp:ListItem Text="Read"></asp:ListItem>
<asp:ListItem Text="Update"></asp:ListItem>
<asp:ListItem Text="Delete"></asp:ListItem>
</asp:CheckBoxList>
只需创建一个像这样的通用功能
Just create a common function like this
private void SetCheckBoxListSelection(CheckBoxList cbxlist,string OptionName, bool Value)
{
var item=cbxlist.Items.Cast<ListItem>().Where(li => li.Text.ToLower().Equals(OptionName.ToLower())).FirstOrDefault();
if (item != null) item.Selected = Value;
}
然后调用此函数
通过
Then call this function
by passing the
SetCheckBoxListSelection(chkEmplyeeMaster,"View",TView==1?true:false);
这篇关于来自多个sql表列的问题Checkboxlist填充的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!