填充datagridview复选框 [英] Populating a datagridview checkboxes

问题描述

大家好，

我需要从SQL db中填充表
进入datagridview.我的问题是最后一栏
是复选框.数据库中必须
的列 触发将这些复选框归档为"1和0"

如果为零，则必须取消选中该复选框，并且
当其为1时，必须对其进行检查.

请任何帮助将被申请

这是我在填充网格时使用的结构:

Hi all,

I need to populate a table from the SQL db
into a datagridview. My issue is the last column
is check boxes. The column in the DB that has to
trigger these check boxes is filed with "1 and 0"

If its a zero the check box must be unchecked and
when its 1 it must be checked.

Please any help would be appriciated

This is the structure I use when populating the grid:

clsConnection sqlConn = new clsConnection();
            SqlCommand sqlComm = new SqlCommand();
            DataTable dt = new DataTable();

            sqlComm.Connection = sqlConn.connection;
            sqlComm.CommandType = CommandType.StoredProcedure;
            sqlComm.CommandText = "ElectricityData.Schedules_LoadGrid";
            sqlComm.Parameters.Add("@MeterID", SqlDbType.Int).Value = iMeterID2;
            sqlComm.Parameters.Add("@ReadingType", SqlDbType.VarChar, 50).Value = cboReadingType2.Text.ToString().Trim();

            SqlDataAdapter da = new SqlDataAdapter();
            da.SelectCommand = sqlComm;
            da.Fill(dt);
            dgvSchedules.ReadOnly = true;
            dgvSchedules.Rows.Clear();

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                dgvSchedules.Rows.Add(dt.Rows[i]["MeterNumber"].ToString(),
                                     dt.Rows[i]["Description"].ToString(),
                                     dt.Rows[i]["Type"].ToString(),
                                     dt.Rows[i]["DateTimeFrom"].ToString(),
                                     dt.Rows[i]["Enabled"].ToString());
            }

推荐答案

尝试以下操作:-

try this:-

clsConnection sqlConn = new clsConnection();
            SqlCommand sqlComm = new SqlCommand();
            DataTable dt = new DataTable();
 
            sqlComm.Connection = sqlConn.connection;
            sqlComm.CommandType = CommandType.StoredProcedure;
            sqlComm.CommandText = "ElectricityData.Schedules_LoadGrid";
            sqlComm.Parameters.Add("@MeterID", SqlDbType.Int).Value = iMeterID2;
            sqlComm.Parameters.Add("@ReadingType", SqlDbType.VarChar, 50).Value = cboReadingType2.Text.ToString().Trim();
 
            SqlDataAdapter da = new SqlDataAdapter();
            da.SelectCommand = sqlComm;
            da.Fill(dt);
            dgvSchedules.ReadOnly = true;
            dgvSchedules.Rows.Clear();
 
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                dgvSchedules.Rows.Add();
                dgvSchedules.Rows[i].Cells["colMeterNumber"].Value=dt.Rows[i]["MeterNumber"].ToString();
                dgvSchedules.Rows[i].Cells["colDescription"].Value=dt.Rows[i]["Description"].ToString();
                dgvSchedules.Rows[i].Cells["colType"].Value=dt.Rows[i]["Type"].ToString();
                dgvSchedules.Rows[i].Cells["colDateTimeFrom"].Value=dt.Rows[i]["DateTimeFrom"].ToString();
                if(Convert.ToBoolean(dt.Rows[i]["Enabled"])==false)
                {
                 dgvSchedules.Rows[i].Cells["colEnabled"].Value=false;
                }
                else(Convert.ToBoolean(dt.Rows[i]["Enabled"])==true)
                {
                 dgvSchedules.Rows[i].Cells["colEnabled"].Value=true;
                }
            }

如果您有帮助，请不要忘记将其标记为答案.

谢谢

Please don''t forget to mark this as your answer if it helps you out.

Thanks

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