如何选择复选框 [英] how to select checkbox

问题描述

当我从表单中选择多个复选框时，如何在数据库中存储nd以及如何为此编写条件????

when i select multiple checkbox from form then how to store in database nd how to write if condition for this?????

推荐答案

在单列中插入所选数据，您可以使用以下代码将数据存储到数据库中.它将使用逗号作为分隔符插入值.

If you want to insert the selected data in single column, you can use following code for storing the data into database. It will be inserting values with comma as a separator.

string selectedItems = string.Empty; 
foreach (ListItem item in this.CheckBoxList1.Items) 
{
    if (item.Selected) 
                selectedItems += item + ","; 
}
SqlCommand cmd = new SqlCommand("Insert into YOUR_TABLE(YOUR_COLUMN) values('" + selectedItems + "')", cn); 
cn.Open(); // I am assuming that you have written down the connection string. 
int iCount = cmd.ExecuteNonQuery(); 
cn.Close();

用于选择:

For selecting:

void LoadCheckList() 
    { 
        string selectedItems = ""; 
        SqlCommand cmd = new SqlCommand("Select YOUR_COLUMN from YOUR_TABLE", cn); // Write your Query i have taken as sample 
        SqlDataReader dr; 
        cn.Open(); 
        dr = cmd.ExecuteReader(); 
        if (dr.Read()) 
        { 
            selectedItems = dr["selectedItems"].ToString(); 
        }
        dr.Close();
        cn.Close(); 
        string[] arr = selectedItems.Split(','); 
        foreach (ListItem item in this.CheckBoxList1.Items) 
        { 
            foreach (string s in arr) 
            { 
                if (item.Text== s) 
                { 
                    item.Selected = true; 
                } 
            } 
        } 
    }

foreach(ListItem item in CheckBoxList1.Items)
            if(item.Selected)
                //Here you can get selected item's value 

在这里您可以访问所有选中的元素.

here you can access all the checked elements.

foreach复选框，格式为

if(CheckBox.Checked)
var a = ??? //分配

foreach Checkbox in the form

if(CheckBox.Checked)
var a = ??? // assign

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