我有一個位類型（布爾值）的 SQL 列，我可以從顯示這些復選框的數據網格中選中或取消選中我選擇的某些項目?，F在我想要一個復選框來選擇或取消選擇數據網格中的所有復選框。我已經到達了這段代碼：private void Chk_All_Checked(object sender, RoutedEventArgs e){ sqliteCon.Open(); if (sqliteCon.State == System.Data.ConnectionState.Open) { CORRENTE string q = @"UPDATE tabL SET selection = (CASE WHEN (SELECT selection FROM tabL ) = 0 THEN 1 ELSE 0 END) WHERE ?????????????????????"; SqlCommand cmd = new SqlCommand(q, sqliteCon); cmd.ExecuteNonQuery(); MessageBox.Show("All Items Checked"); } sqliteCon.Close();}“WHERE idL=@CURRENT”是錯誤的這是另一種嘗試，但效果不佳：private void Chk_All_Checked(object sender, RoutedEventArgs e){ sqliteCon.Open(); if (sqliteCon.State == System.Data.ConnectionState.Open) { string q = @"UPDATE tabL SET selection = 1"; SqlCommand cmd = new SqlCommand(q, sqliteCon); cmd.ExecuteNonQuery(); MessageBox.Show("All Items Checked"); string q2 = @"UPDATE tabL SET selection = 0"; SqlCommand cmd2 = new SqlCommand(q2, sqliteCon); cmd2.ExecuteNonQuery(); MessageBox.Show("All Items DeChecked"); } sqliteCon.Close();}
2 回答
Smart貓小萌
TA貢獻1911條經驗 獲得超7個贊
378 次查看 0 個解決方案，但我自己找到了一個 chkbox 對象有兩個事件處理程序，一個用于檢查，一個用于 deceked。
private void Chk_All_Checked(object sender, RoutedEventArgs e)
{
sqliteCon.Open();
if (sqliteCon.State == System.Data.ConnectionState.Open)
{
if (chk_All.IsChecked == true) {
string q = @"UPDATE tabList
SET selection = 1";
SqlCommand cmd = new SqlCommand(q, sqliteCon);
cmd.ExecuteNonQuery();
MessageBox.Show("All Items Checked");
}
}
sqliteCon.Close();
}
private void CheckBox_Unchecked(object sender, RoutedEventArgs e)
{
sqliteCon.Open();
if (sqliteCon.State == System.Data.ConnectionState.Open)
{
if (chk_All.IsChecked == false)
{
string q2 = @"UPDATE tabList
SET selection = 0";
SqlCommand cmd2 = new SqlCommand(q2, sqliteCon);
cmd2.ExecuteNonQuery();
MessageBox.Show("All Items DeChecked");
}
}
sqliteCon.Close();
}
侃侃爾雅
TA貢獻1801條經驗 獲得超16個贊
使用以下代碼：
private void DataGridView_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0 && e.ColumnIndex == 0)
{
foreach (DataGridViewRow row in dataGridView1.Rows)
{
if (row.Index == e.RowIndex)
{
row.Cells["checkBoxColumn"].Value =
!Convert.ToBoolean(row.Cells["checkBoxColumn"].EditedFormattedValue);
}
else
{
row.Cells["checkBoxColumn"].Value = false;
}
}
}
}
- 2 回答
- 0 關注
- 173 瀏覽
添加回答
舉報
0/150
提交
取消