我想从SQL数据库中检索数据到组合框和复选框。我重新检查了组合框的数据，但不知道如何检索复选框的数据。 [英] I want to retrive data from SQL database to combo box and check box. I retrived data of comboboxes but dontknow how to retrive data of a checkbox.

问题描述

private void routeedit_Load(object sender, EventArgs e)
        {
            con = new SqlConnection(@"Data Source=M2\SQL2016;Initial Catalog=inventoryDB;Integrated Security=True");
            con.Open();
            string query = "SELECT rname FROM routeDB";
            string quer = "SELECT idc FROM routeDB";
            string que = "SELECT rcode FROM routeDB";
            SqlDataAdapter da = new SqlDataAdapter(query, con);
            SqlDataAdapter sda = new SqlDataAdapter(quer, con);
            SqlDataAdapter sdp = new SqlDataAdapter(que, con);
            DataSet ds = new DataSet();
            DataSet sds = new DataSet();
            DataSet sd = new DataSet();
            da.Fill(ds, "routeDB");
            sda.Fill(sds, "routeDB");
            sdp.Fill(sd, "routeDB");
            comboroute.DisplayMember = "rname";
            comboroute.ValueMember = "rname";
            comboroute.DataSource = ds.Tables["routeDB"];
            comborec.DisplayMember = "rcode";
            comborec.ValueMember = "rcode";
            comborec.DataSource = sd.Tables["routeDB"];
            comboroute.SelectedIndex = -1;
            comborec.SelectedIndex = -1;
            boxidc //this is checkbox. Data is 1 then i have to chek or data is 0 then uncheck. how to display that from database
        }

我尝试了什么：



我重新获取数据库文件的数据并显示给组合框。但是面对问题来检索复选框的数据。

What I have tried:

I retrived data of databse file and displayed to comboboxes. but facing problem to retrive data for checkbox.

推荐答案

使用已检查 [ ^ ] property

use Checked[^] property

var value = 0;
     bool isChecked = value == 1;
     boxidc.Checked = isChecked;

这篇关于我想从SQL数据库中检索数据到组合框和复选框。我重新检查了组合框的数据，但不知道如何检索复选框的数据。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！