最近转做winform开发,很多都不熟,希望高手指教!
我已经写好了在datagrid上绑定checkbox
private void BindDataGridWithCheckbox(DataGrid datagrid, string connectionString, string commandString, string itermName)
{
SqlConnection connection = new SqlConnection(connectionString);
SqlDataAdapter da = new SqlDataAdapter(commandString, connectionString);
DataSet ds = new DataSet();
da.Fill(ds,"table");
DataTable dt = new DataTable();
dt = ds.Tables["table"]; DataColumn dtcCheck = new DataColumn(itermName);
dtcCheck.DataType = System.Type.GetType("System.Boolean");
dtcCheck.DefaultValue = false; dt.Columns.Add(dtcCheck);
datagrid.DataSource = dt;
}
但是我不知道 如何写checkbox的点击事件,还有如何确定选定的这些行
我已经写好了在datagrid上绑定checkbox
private void BindDataGridWithCheckbox(DataGrid datagrid, string connectionString, string commandString, string itermName)
{
SqlConnection connection = new SqlConnection(connectionString);
SqlDataAdapter da = new SqlDataAdapter(commandString, connectionString);
DataSet ds = new DataSet();
da.Fill(ds,"table");
DataTable dt = new DataTable();
dt = ds.Tables["table"]; DataColumn dtcCheck = new DataColumn(itermName);
dtcCheck.DataType = System.Type.GetType("System.Boolean");
dtcCheck.DefaultValue = false; dt.Columns.Add(dtcCheck);
datagrid.DataSource = dt;
}
但是我不知道 如何写checkbox的点击事件,还有如何确定选定的这些行
{
//判断是你的下拉框,关联事件
}
DataRow [] dr=null;
for(int i=0;i<ds_Table.Tables[0].Rows.Count;i++)
{
dr=ds_Table.Tables[0].Select("itermName=1");
} for(int i=0;i<dr.Length;i++)
{
MessageBox.Show(dr[i]["job_id"].ToString());
MessageBox.Show(dr[i]["job_desc"].ToString());
MessageBox.Show(dr[i]["min_lvl"].ToString());
MessageBox.Show(dr[i]["max_lvl"].ToString());
}
DataTable ds_Table=(DataTable)this.dataGrid1.DataSource;
DataRow [] dr=null;
for(int i=0;i<ds_Table.Rows.Count;i++)
{
dr=ds_Table.Select("aaa=1");//aaa为定义的新列名
} for(int i=0;i<dr.Length;i++)
{
MessageBox.Show(dr[i]["AUFNR"].ToString());
MessageBox.Show(dr[i]["SUB_AUFNR"].ToString());
MessageBox.Show(dr[i]["MATNR"].ToString());
MessageBox.Show(dr[i]["MAKT_Z"].ToString());
}