kehinde adeoya

kehinde adeoya

  • NA
  • 2
  • 12.2k

Get selected checkboxes

Mar 12 2012 12:16 PM
[code]
public void personPanel_Click(object sender, EventArgs e) { string DBConnection = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\LinksApplication.mdf;Integrated Security=True;User Instance=True"; SqlConnection sqlConnection = new SqlConnection(DBConnection); sqlConnection.Open(); try { SqlCommand sqlCommand = sqlConnection.CreateCommand(); sqlCommand.CommandText = "SELECT * FROM Person"; sqlCommand.CommandType = System.Data.CommandType.Text; SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand); DataSet dataSet = new DataSet(); sqlDataAdapter.Fill(dataSet, "Person"); DataTable dataTable = dataSet.Tables["Person"]; int rowsPerson = dataSet.Tables["Person"].Rows.Count; int count = 0; RadioButton[] personRadio = new RadioButton[rowsPerson]; foreach (DataRow dataRow in dataTable.Rows) { string strFirtsname = dataRow["firstname"].ToString(); string strLastname = dataRow["lastname"].ToString(); personRadio[count] = new RadioButton(); personRadio[count].Name = personRadio[count].ToString(); personRadio[count].Text = strFirtsname + " " + strLastname; personRadio[count].TabIndex = count; personRadio[count].Location = new Point(20, count * 20); personRadio[count].AutoCheck = true; personRadio[count].CheckedChanged += new EventHandler(personRadio_CheckChanged); personPanel.Controls.Add(personRadio[count]); personPanel.Visible = true; count++; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlConnection.Close(); } } private void personRadio_CheckChanged(object sender, System.EventArgs e) { RadioButton personRadio = (RadioButton)sender; } //+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ private void circumstancePanel_Click(object sender, EventArgs e) { string DBConnection = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\LinksApplication.mdf;Integrated Security=True;User Instance=True"; SqlConnection sqlConnection = new SqlConnection(DBConnection); try { sqlConnection.Open(); SqlCommand sqlCommand = sqlConnection.CreateCommand(); sqlCommand.CommandType = System.Data.CommandType.Text; sqlCommand.CommandText = "SELECT * FROM Circumstance"; SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand); DataSet dataSet = new DataSet(); sqlDataAdapter.Fill(dataSet, "Circumstance"); DataTable dataTable = dataSet.Tables["Circumstance"]; int rowCircumstance = dataSet.Tables["Circumstance"].Rows.Count; int count = 0; CheckBox[] checkCircumstance = new CheckBox[rowCircumstance]; foreach (DataRow dataRow in dataTable.Rows) { string strRole = dataRow["circumstance"].ToString(); checkCircumstance[count] = new CheckBox(); checkCircumstance[count].Name = checkCircumstance[count].ToString(); checkCircumstance[count].Text = strRole; checkCircumstance[count].TabIndex = count; checkCircumstance[count].Location = new Point(20, count * 20); checkCircumstance[count].AutoCheck = true; circumstancePanel.Controls.Add(checkCircumstance[count]); circumstancePanel.Visible = true; count++; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlConnection.Close(); } } //+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ private void linkUser_Click(object sender, EventArgs e) { if(personPanel.Controls!=null){ foreach(Control items in personPanel.Controls){ } if(circumstancePanel.Controls!=null){ foreach(Controls .........//How do i write the code for the selected checkbox(es) ){ } [/code]
Explain in bits what I want to achieve in this line of codes:
personPanel contains dynamically added radio buttons based on the number of items in the database table
circumstancePanel contains dynamically added checkboxes based on the number of items in the database table
Now I want to use linkUser_Click(sender, e) to achieve this:
When a personRadio (radio Button) is clicked on the interface of personPanel and many other checkboxes are checked in circumstancePanel i want it to work this way:
Anytime that the same radio button in personPanel interface is clicked it should display the checked checkbox as its assigned values. I have a panel I want to add this to already. 
My immense appreciation goes beyond writing. Thanks. Gold bless in Jesus name.



Answers (1)