To do a program today, select the option from the CheckBoxList into the database, and then to read the data from the database and also to correspond to the corresponding options up, stored in the database is very simple, with a circular deposit on the line, in order to read the convenience, I added a comma after each, the code is as follows:
<asp:checkboxlist id= "Yuyan" runat= "server" repeatdirection= "Horizontal" repeatcolumns= "4" >
<asp:ListItem> Mandarin </asp:ListItem>
<asp:ListItem> Shanghai Dialect </asp:ListItem>
<asp:ListItem> Minnan Language </asp:ListItem>
<asp:ListItem> Hakka </asp:ListItem>
<asp:ListItem> Cantonese </asp:ListItem>
<asp:ListItem> English </asp:ListItem>
<asp:ListItem> Japanese </asp:ListItem>
<asp:ListItem> German </asp:ListItem>
<asp:ListItem> French </asp:ListItem>
<asp:ListItem> Russian </asp:ListItem>
<asp:ListItem> other </asp:ListItem>
</asp:CheckBoxList>
Save in database code:
String Yuyan = "";
foreach (ListItem items in This.yuyan.Items)
{
if (items. Selected = = True)
{
Yuyan = Yuyan + items. Text + ",";
}
}
String sql ... Write database slightly
read out the corresponding data and correspond to the hits
String Yuyan = dt. Rows[0]["Languages"]. ToString ();
string[] Yuyanlist = Yuyan. Split (new char[] {', '});
/** This is the code that I went wrong with.
foreach (String yuyansingle in Yuyanlist) {
if (Yuyanlist[i]==this.yuyan.items.text) {
This.yuyan.items.selected=true;
****}
***}
**/
for (int i = 0; i < yuyanlist. length-1;i++)
{
This.yuyan.Items.FindByText (Yuyanlist[i]). Selected = true;//There is also a findbyvalue (""), this paragraph is blocking my focus of this work.
}
Because the beginning is not familiar with, so the thing that uses if (Yuyanlist[i]==this.yuyan.items.text) result is not good, then this.yuyan.items.FindByText in the net to use (Yuyanlist[i]. Selected=true;), but still no, the error is not found in the database of the appropriate option, and then to see that post, see a saying "The last item of the bean, also added into the," I just remembered that I did so, so that split with the splitting will be a more empty value out, So there will be such a mistake, and finally change to for (int i = 0; i < yuyanlist. length-1;i++), OK, finish ...
