Toggle buttons on and off based on database value in C#

Question

I am trying to make a button inside a webform visible if data available. I have a database with a column name NCID, then in a views I count the NCID's. and I a have btn1 till btn9 hidden. If NCID Count is 1 show button btn1, if NCID Count is 2 then show btn1 and btn2.

How can I target the Button ID to make it visible or hide it?

I tried the following but it is not working for me.

while (sr.Read())
{
    string NCID = sr["NCID"].ToString();
    int nc2 = Convert.ToInt32(NCID);
    int x = 1;

    do
    {
        string btnx = "btn" + x;
        btnx.Visible = true;

        x++;
    } while (x <= nc2);
}

con.Close();

I tried the following but it is not working for me!! Define not working. What did you expect to happen? What actually happened? — mjwills
– mjwills, Commented Aug 7, 2017 at 13:35
See : msdn.microsoft.com/en-us/library/486wc64h(v=vs.110).aspx — Steve
– Steve, Commented Aug 7, 2017 at 13:37

Jared · Accepted Answer · 2017-08-08 14:19:27Z

1

If this is a Windows Forms app, you can use:

Controls.Find(btnx, true).First().Visible = true;

Find control by name from Windows Forms controls

https://msdn.microsoft.com/en-us/library/system.windows.forms.control.controlcollection.find(v=vs.110).aspx

If it's WebForms, you can use:

FindControl(btnx).Visible = true;

https://msdn.microsoft.com/en-us/library/486wc64h(v=vs.110).aspx

edited Aug 8, 2017 at 14:19

answered Aug 7, 2017 at 13:36

Jared

1,39511 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Hemin T Over a year ago

I tried Controls.FindControl(btnx).Visible = true; then I get an error "ControlCollection does not contain a definition for FindControl"

Jared Over a year ago

Can you update your question to show how you're declaring controls in HTML?

Hemin T Over a year ago

string NCID = sr["NCID"].ToString(); int nc2 = Convert.ToInt32(NCID); int x = 1; do { string btnx = "btn" + x; Controls.FindControl(btnx).Visible = true; x++; } while (x <= nc2);

Jared Over a year ago

Sorry, it's been a while since I did WebForms. I updated the answer to show you can just use FindControl, not Controls.FindControl, after confirming this works in an old WebForms project.

Missing_DLL · Accepted Answer · 2017-08-07 13:53:10Z

0

(see jareds answer)

for (int i = 0; i < x; i++) //smaller then ammount of lines returned      
{
  Controls.Find(btnx + i).Visible = true; //add visibility to wichever control (found by name) you wanted to add
}

edited Aug 7, 2017 at 13:53

Missing_DLL

8231 gold badge13 silver badges25 bronze badges

answered Aug 7, 2017 at 13:40

Freek W.

4166 silver badges21 bronze badges

Collectives™ on Stack Overflow

Toggle buttons on and off based on database value in C#

2 Answers 2

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related