111,092
社区成员




private void Room_Load(object sender, EventArgs e)
{
string sql = "select RoomNum as 房间号 from T_Room_Info where JQH=1 order by RoomNum";
DataSet ds = DbHelperSQL.Query(sql);
dgv_one.DataSource = ds.Tables[0];
DataGridViewButtonColumn col_btn_insert = new DataGridViewButtonColumn();
col_btn_insert.HeaderText = "操作";
col_btn_insert.Text = "打开";
col_btn_insert.DefaultCellStyle.NullValue = true;
col_btn_insert.UseColumnTextForButtonValue = true;//
dgv_one.Columns.Add(col_btn_insert);
int row;
for (row = 0; row < this.dgv_one.RowCount; row++)
{
string roomnum = this.dgv_one[0, row].Value.ToString();
string sql_state = "select * from T_VideoCamera where DoorBH='" + roomnum + "' and ifuse=1";
DataSet ds_state = DbHelperSQL.Query(sql_state);
if (ds_state.Tables[0].Rows.Count > 0)
{
this.dgv_one.Rows[row].Cells[1].Value = "打开";
}
else
{
this.dgv_one.Rows[row].Cells[1].Value = "关闭";//这句话就是赋值不成功
// MessageBox.Show(this.dgv_one.Rows[row].Cells[1].Value.ToString());//这样写又能取到原始值为“打开”
}
}
}
private void Room_Load(object sender, EventArgs e)
{
string sql = "select RoomNum as 房间号 from T_Room_Info where JQH=1 order by RoomNum";
DataSet ds = DbHelperSQL.Query(sql);
dgv_one.DataSource = ds.Tables[0];
DataGridViewButtonColumn col_btn_insert = new DataGridViewButtonColumn();
col_btn_insert.HeaderText = "操作";
col_btn_insert.Text = "打开";
dgv_one.Columns.Add(col_btn_insert);
for (int row = 0; row < this.dgv_one.RowCount; row++)
{
string roomnum = this.dgv_one[0, row].Value.ToString();
string sql_state = "select * from T_VideoCamera where DoorBH='" + roomnum + "' and ifuse=1";
DataSet ds_state = DbHelperSQL.Query(sql_state);
if (ds_state.Tables[0].Rows.Count > 0)
{
this.dgv_one.Rows[row].Cells[1].Value = "打开";
}
else
{
this.dgv_one.Rows[row].Cells[1].Value = "关闭";
}
}
}
DataGridViewButtonColumn 按钮 = new DataGridViewButtonColumn();
按钮.HeaderText = "操作";
列表.Columns.Add(按钮);
for (int 行 = 0; 行 < 列表.RowCount; 行++)
列表.Rows[行].Cells[3].Value = 行 % 2 == 0 ? "打开" : "关闭";