如果checkedListBox1项为true，则将检查项目 [英] IF checkedListBox1 Items are true then items will be checked

问题描述

//Create SQL strings
    string sql = "select *from DatabaseLogin where user_id='" + textBox2.Text + "'";

    using (OleDbConnection dbConnection = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\MIS SYSTEM\AniPharmic\AniPharmic\MedicalDb.accdb;Jet OLEDB:Database Password="))
    {
        //dbAdapter = new OleDbDataAdapter(sql, dbConnection); //You dont need it
        //dataTable = new DataTable(); //don't need it
        dbConnection.Open();
        using (OleDbCommand oCommand = new OleDbCommand(sql, dbConnection))
        {
            using (OleDbDataReader dbReader = oCommand.ExecuteReader())
            {
                while (dbReader.Read())
                {
                    //int iRow = dataTable.Rows.Count; //always zero you never used the datable
                    //MessageBox.Show("Count " + iRow.ToString());
                    //MessageBox.Show(dbReader.ToString());
                    checkedListBox1.Items.Add(dbReader["stckdemge"].ToString());
               //     checkBox1(dbReader[].ToString()

                }

            } //reader closed and disposed
        }//command disposed
    } //connection closed

推荐答案

您需要创建ListItem对象和其Selected属性设置为true。请参阅下面的代码

You need to create ListItem object and its Selected property set true value. Please see the code bellow

<div>
    <asp:checkboxlist runat="server" id="chkList" />
</div>

protected void Page_Load(object sender, EventArgs e)
{
var item = new ListItem("Good Morning");
item.Selected = true;
var item2 = new ListItem("Good AfterNoon");
item2.Selected = true;
var item3 = new ListItem("Good Eventing");
chkList.Items.Add(item);
chkList.Items.Add(item2);
chkList.Items.Add(item3);
}

这篇关于如果checkedListBox1项为true，则将检查项目的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！