[RESOLVED] iteration from the database

Code:

---

private void rolePanel_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);
            CheckBox roleCheck = new CheckBox();
            //Panel rolePanel = new Panel();
            try
            {
                sqlConnection.Open();
                SqlCommand sqlCommand = sqlConnection.CreateCommand();
                sqlCommand.CommandType = System.Data.CommandType.Text;
                sqlCommand.CommandText = "SELECT * FROM Role";
                /*SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand);
                DataSet dataSet = new DataSet();
                sqlDataAdapter.Fill(dataSet, "Role");
                DataTable dataTable=dataSet.Tables["Role"];
                foreach(DataRow dataRow in dataTable.Rows){
                new CheckBox().Text=dataRow["role"].ToString();
                rolePanel.Controls.Add(new CheckBox());
                rolePanel.Visible = true;*/
               
                SqlDataReader sqlDatareader = sqlCommand.ExecuteReader();

                //CREATE AN INSTANCE OF A CHECKBOX AND SET ATTRIBUTES
                roleCheck.TextAlign = ContentAlignment.MiddleRight;

                while (sqlDatareader.Read())
                {
                    roleCheck.Text = sqlDatareader["role"].ToString();
                    rolePanel.Controls.Add(roleCheck);
                    rolePanel.Visible = true;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
            finally
            {
                sqlConnection.Close();
            }
        }

---

PLEASE KINDLY HELP ME OUT. I WANT TO ITERATE THE VALUES FROM THE DATABASE TABLE INTO A PANEL(rolePanel) AND ADDING CHECKBOX TO EACH ITEM, BUT FOR NOW IT ONLY POPULATES IT WITH JUST ONE ITEM FROM THE DATABASE TABLE. I THINK MY ITERATE STATEMENT ISN'T RIGHT, WHAT SHOULD I DO? THANKS. GOD BLESS IN JESUS NAME.

There is a lot of your code which is done between /* ....*/ so this only makes your request a bit unreadable Basically if you want to add Controls in each iteration you need to create a new one. Thats your main outpoint in your code, Additional you should be able to check your code to
a) is it ok so it could be comppiled if not remove all error so it can be compiled
b) Debug your code running it line by liine so you see if your items are read from the database and if your controls are created and correctly added to your panel

In the moment this seems me both to be a problem

A big thanks for your observation. I appreciate this.

Code:

---

private 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"];

                foreach(DataRow dataRow in dataTable.Rows){
                    int rowsPerson = dataSet.Tables["Person"].Rows.Count;
                    string strFirtsname=dataRow["firstname"].ToString();
                    string strLastname=dataRow["lastname"].ToString();

                    for (int count = 0; count < rowsPerson; count++)
                    {
                        RadioButton[] personRadio = new RadioButton[rowsPerson];
                        personRadio[count] = new RadioButton();
                        personRadio[count].Name = personRadio[count].ToString();
                        MessageBox.Show("No. of Rows are : " + personRadio[count].ToString());
                        personRadio[count].Text = strFirtsname + " " + strLastname;
                        // MessageBox.Show("No. of Rows are : " + personRadio[count].Text.ToString());
                        personRadio[count].TabIndex = count;
                        personRadio[count].Location = new Point(0, count * 20);
                        personRadio[count].AutoCheck = true;
                        personPanel.Controls.Add(personRadio[count]);
                        personPanel.Visible = true;
                    }
                }

           
            }
            catch(Exception ex){
                MessageBox.Show(ex.ToString());
            }
            finally{
           
            }
        }

---

I have added more codes to it but now it is iterating the same Roll according to the number of Roles in the table. For example let me say if I have 3 roles in a table, it assigns 3 radioButtons to only a single row(in the table)

ie let say I have the following in my table
1. jon
2. fred
3.kehinde

it iterates 9 times and assigns radio button three times to the first role alone as follows:

(radioButton) jon
(radioButton) jon
(radioButton) jon

what should I do? thanks.

Code:

---

private 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 count = 0;; //Adsd this
              // The following needs to be placed outside the loop
              int rowsPerson = dataSet.Tables["Person"].Rows.Count;
              RadioButton[] personRadio = new RadioButton[rowsPerson];             
 foreach(DataRow dataRow in dataTable.Rows){
                   
                    string strFirtsname=dataRow["firstname"].ToString();
                    string strLastname=dataRow["lastname"].ToString();
 
                  //  for (int count = 0; count < rowsPerson; count++)
                  // {  Why would you have a loop iin a loop
                        RadioButton[] personRadio = new RadioButton[rowsPerson]; // Thiis needs to be outside the loop because otherwise you would create a new aeeay each time you arer lpoping through that
                        personRadio[count] = new RadioButton();
                        personRadio[count].Name = personRadio[count].ToString();
                        MessageBox.Show("No. of Rows are : " + personRadio[count].ToString());
                        personRadio[count].Text = strFirtsname + " " + strLastname;
                        // MessageBox.Show("No. of Rows are : " + personRadio[count].Text.ToString());
                        personRadio[count].TabIndex = count;
                        personRadio[count].Location = new Point(20, count * 20);
                        personRadio[count].AutoCheck = true;
                        personPanel.Controls.Add(personRadio[count]);
                        personPanel.Visible = true;
                      count ++; // Add this
                  // } only one loop so no longer needed
                }
 
 
            }
            catch(Exception ex){
                MessageBox.Show(ex.ToString());
            }
            finally{
 
            }
        }

---

As already mentione any array in that nneds to be outside any loop.. Otherwise you will get a lot of problems The array would only life as long as you are inside the loop so a new array would be created each time.

Just want to show my gratitude for your great help. It works perfectly. Thanks. God bless in Jesus name.

Code:

---

private void rolePanel_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);
            CheckBox roleCheck = new CheckBox();

            try
            {
                sqlConnection.Open();
                SqlCommand sqlCommand = sqlConnection.CreateCommand();
                sqlCommand.CommandType = System.Data.CommandType.Text;
                sqlCommand.CommandText = "SELECT * FROM Role";
                SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand);
                DataSet dataSet = new DataSet();
                sqlDataAdapter.Fill(dataSet, "Role");
                DataTable dataTable = dataSet.Tables["Role"];
                int rowRole = dataSet.Tables["Role"].Rows.Count;

                int count = 0;
                CheckBox[] checkRole = new CheckBox[rowRole];
                foreach (DataRow dataRow in dataTable.Rows)
                {
                    string strRole = dataRow["role"].ToString();
                    checkRole[count] = new CheckBox();
                    checkRole[count].Name = checkRole[count].ToString();
                    checkRole[count].Text = strRole;
                    checkRole[count].TabIndex = count;
                    checkRole[count].Location = new Point(20, count * 20);
                    checkRole[count].AutoCheck = true;
                    rolePanel.Controls.Add(checkRole[count]);
                    rolePanel.Visible = true;
                    count++;

                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
            finally
            {
                sqlConnection.Close();
            }
        }

---

this is working properly. The next thing I want to do is to get the selected radio button. Your contribution is highly appreciated.

Code:

---

private void rolePanel_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);
            CheckBox roleCheck = new CheckBox();
 
            try
            {
                sqlConnection.Open();
                SqlCommand sqlCommand = sqlConnection.CreateCommand();
                sqlCommand.CommandType = System.Data.CommandType.Text;
                sqlCommand.CommandText = "SELECT * FROM Role";
                SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand);
                DataSet dataSet = new DataSet();
                sqlDataAdapter.Fill(dataSet, "Role");
                DataTable dataTable = dataSet.Tables["Role"];
                int rowRole = dataSet.Tables["Role"].Rows.Count;
 
                int count = 0;
                CheckBox[] checkRole = new CheckBox[rowRole];
                foreach (DataRow dataRow in dataTable.Rows)
                {
                    string strRole = dataRow["role"].ToString();
                    checkRole[count] = new CheckBox();
                    checkRole[count].Name = checkRole[count].ToString();
                    checkRole[count].Text = strRole;
                    checkRole[count].TabIndex = count;
                    checkRole[count].Location = new Point(20, count * 20);
                    checkRole[count].AutoCheck = true;
                  // Add a delegate here to the control so you are able to get clicks to thast checkboxes
                    checkRole[count].Click += new EventHandler(RolePanel_Click);                   rolePanel.Controls.Add(checkRole[count]);
                    rolePanel.Visible = true;
                    count++;
 
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
            finally
            {
                sqlConnection.Close();
            }
        }
      // Add the e delegate
        void RolePanel_Click(object sender, EventArgs e) {
            CheckBox actBox = (CheckBox)sender;
            int count = actBox.TabIndex;
       
        }

---

This language is a bit advance than my level of knowledge in C# now, I am only 3wks old in this, please can you give me code that relates to this( Add a delegate here to the control so you are able to get clicks to that checkboxes). Thanks.

I added the code its the line after my red text and the delegate is done in the bottom of the code. I have colored the code to blue lines now.

I can not but tell you that my appreciation goes beyond writing. Thanks a lot!

Quote:

---

Originally Posted by ken4ward

I can not but tell you that my appreciation goes beyond writing. Thanks a lot!

---

You are welcome

Code:

---

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].personRadio_CheckedChanged = new EventHandler(personRadio_CheckChanged);
                    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;
                    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;
            int count = personRadio.TabIndex;
        }

---

Can not explain why the CheckChanged eventHandler is not working. Please, I need your insight. Thanks.

Code:

---

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();
                  // This even will not compile I think !!! Because tzhere is no Event called personRadio_CheckedChanged                 
                  personRadio[count].personRadio_CheckedChanged = new EventHandler(personRadio_CheckChanged);
                  //THIS NEEDS TO BE
                  personRadio[count].CheckedChanged = new EventHandler(personRadio_CheckChanged);
                    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;
                    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;
            int count = personRadio.TabIndex;
        }

---

OK As I can see you did not get the idea behind all of that. So I'll explain that to you.
Each Control may have Properties, methods and and events
Using the intellisense will show you all of them
This way, when you type
personRadio[count]. After typing the dot the intellisense will open and show you all of them. No you easily can see what events the control provides.

Now click to that event you want to use e.g
personRadio[count].CheckedChanged
and type += after you have choosen the event you want to use.
The code now will be
personRadio[count].CheckedChanged +=

Now two times press the TAB key of your keyboard and you will automatically get something like the following

Code:

---

personRadio[count].CheckedChanged = new EventHandler(personRadio_CheckChanged);

---

You can see that as well the binding of the delegate to the event is done on the one side and additional the methodstub of that delegate is created

Code:

---

  private void personRadio_CheckChanged(object sender, System.EventArgs e)
        {
                 
        }

---

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) ){
               
                }

---

Hello Jonny, your contribution to the success of this my project is really applauding. i heartily say many thanks!

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.

Code:

---


 private void linkUser_Click(object sender, EventArgs e)
        {
                if(circumstancePanel.Controls!=null){
                   
                      for (int i = this.Controls.Count - 1; i >= 0; i--){
                          Control c = this.Controls[i];
                            // now we check if the control is a checkbox
                          if (c.GetType() == typeof(CheckBox) {
                              ((CheckBox)c).Checked = true;
                          }
                    }
                }

---

Hope that helps

I am on it now. Heartily say thanks for your good contributions.

Code:

---

int counter = 0;
          Control control = new Control();
                if(rolePanel.Controls !=null){
                  if(control.GetType()==typeof(CheckBox)){
                      if(((CheckBox)control).Checked==true){

//Not the right code
                          foreach(((CheckBox)control).Checked in rolePanel.Controls.Count){
                         
                          }
                           
                        }
                   
                    }
                }
            }

---

Thanks for your help. This lines of code given me is well explanatory. What i want to achieve is to count the number of selected or checked checkbox(es). How do I get it?

Code:

---

int counter = 0; define this in the header of the class (panel or form)
// in the event delegate where you want to count do the following
              if(rolePanel.Controls !=null){
                  foreach(Control c in rolePanel.Controls){
                      if(c.GetType()==typeof(CheckBox)){
                          if(((CheckBox)c).Checked==true){
                            this.counter ++;
 
                          }
 
                        }
 
                    }
                }

---

BTW zip the program and add it here so I can have a look to it
Its much easier then to help you
Before doing so remove all files in the obj and the bin folder so there is no exe file included to the zip file

On this project I have
1. 10 tables in LinksApplication database
2. 10 forms which could be selected from the combobox on LinkUser form
3. Each 10 forms can insert, update, delete from the database tables that bears their name
4. 3 forms that has 10 panels each: LinkUser, CurrentUser, AllUser to display iterated database table items based on what they are to do

The one I am working on now is LinkUser interface which has 10 panels, 3 buttons-linkUser, allUser, currentUser
This is what I want to achieve:
Each panel gets the values from the tables specific to each.
It assigns radiobutton to value in the Person table and display them on personPanel

It assigns checkbox to value in the other tables and add them to their respective panels.

This is what I want to do. As i am working on LinkUser form. When a value(radiobutton) is selected on personPanel and some checkboxes are checked on rolePanel, circumstancePanel, problemPanel and the LinkUser button is clicked it should assign the checked checkboxes as it values.

Now if I open the CurrentUser form that conains the personPanel items from the database table(Person) and click on any of the radiobutton it should automatically display the selected values on respectively on other panels in the CurrentUser form.

Hope I am much communicating. Thanks.

I would thank you from the bottom of my heart

You did an error The zip file only contains the dln file nothing else But you should dsend all teh application including fatabase only not including any file located in the bin or object folder,
Simple delete all stuff in that folders, They will be created automatically when you are compiling the project next time

All the cs files of the project, the database and resources are needed

The files are bigger that the forum required so it gives me an error of file too big whenever I want to upload to the forum. Is there any better way I could do it? Thanks. Goodmorinig.

Quote:

---

Originally Posted by ken4ward

The files are bigger that the forum required so it gives me an error of file too big whenever I want to upload to the forum. Is there any better way I could do it? Thanks. Goodmorinig.

---

click to my name and write me an email. Sendd the file that way

Code:

---

private void solutionPanel_MouseHover(object sender, EventArgs e)
        {
            Intermediate intermediate = new Intermediate();
            DialogResult dialogues = intermediate.ShowDialog();
            if (e.Equals("solutionPanel"))
            {
                personPanel.Visible = false;
            }
            else
            {
                personPanel.Visible = true;
            }

---

please I want this if I hover solutionPanel should become invisible and intermediate dialog should show. everything is ok but only the if statement. Thanks. So much appreciate your efforts sir. Words can not well compliment your support.

Code:

---

private void solutionPanel_MouseHover(object sender, EventArgs e)
        {
            Intermediate intermediate = new Intermediate();
            DialogResult dialogues = intermediate.ShowDialog();
        // code is waiting until dialog is closed
            if (e.Equals("solutionPanel"))
            {
                personPanel.Visible = false;
            }
            else
            {
                personPanel.Visible = true;            }

---

This cannot do the job, because after you do the show dialog the eexecution of this command halts until the dialog is closed That way your cisible, invisble will not be executed
Put the show dialog in the last line of that commands

Quote:

---

Originally Posted by ken4ward

On this project I have
1. 10 tables in LinksApplication database
....
The one I am working on now is LinkUser interface which has 10 panels, 3 buttons-linkUser, allUser, currentUser
This is what I want to achieve:
Each panel gets the values from the tables specific to each.
It assigns radiobutton to value in the Person table and display them on personPanel

....
This is what I want to do. As i am working on LinkUser form. When a value(radiobutton) is selected on personPanel and some checkboxes are checked on rolePanel, circumstancePanel, problemPanel and the LinkUser button is clicked it should assign the checked checkboxes as it values.

Now if I open the CurrentUser form that conains the personPanel items from the database table(Person) and click on any of the radiobutton it should automatically display the selected values on respectively on other panels in the CurrentUser form.
...

---

The problem is I cannot find any of the code you have already shown here in previous topics in the code you sended me. Even the names of that forms are not existing maybe thhey all are derived from any other form but for eyamole there is no delegate called LinkUser_Click() in this project nor I can find solutionPanel_MouseHover ???
So please which form are you working on or if thhe project I got is not the actual one then pleease send that one, you really are working on

It is still the same, the only thing is that I have changed some names in it. This is the main project. Thanks.

Quote:

---

Originally Posted by ken4ward

It is still the same, the only thing is that I have changed some names in it. This is the main project. Thanks.

---

Maybe, but I cannoz find even one line of code of what you are describing here