dynamic checkboxes

Question

I am new to C#.

I have about 55 checkboxes on a form to choose vaious different options, the labels and labels are dependant on 'frmSchemas.schema' from a previous form.

Is there any way I can get the values from the database to populate on the comboxes dynamically so I dont have to code to read 189 times?

I am sorry if I didnt ask the correct question. I am using the code below but stuck after the dr.Read(); Can anyone help me...

string oradb = "Data Source=";
oradb = oradb + Login.db + ";";
oradb = oradb + "User Id=" + Login.user;
oradb = oradb + ";Password=" + Login.pass + ";";
OracleConnection conn = new OracleConnection(oradb);
conn.Open();
sql = "SELECT GCOS_SCHEMA, PROGRAM_FIELD, DBFIELD,PROGRAM_LABEL FROM GENDBA.SUPTALLYACTIVITIESCONFIG where active ='Y' and GCOS_SCHEMA ='" + frmSchemas.schema + "'";
OracleCommand cmd = new OracleCommand(sql, conn);
cmd.CommandType = CommandType.Text;
OracleDataReader dr = cmd.ExecuteReader();
dr.Read();

DeveloperX · Accepted Answer · 2011-07-04 12:04:39Z

2

change dr.Read(); to

while(dr.Read())
{
 // loop through the table 

}

answered Jul 4, 2011 at 12:04

DeveloperX

4,69319 silver badges22 bronze badges

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

3 Comments

Privesh Over a year ago

i thought of that but what puzzles me is how to assign them to the checkboxes?

DeveloperX Over a year ago

use dr[ fieldname] to read the reader value ,and assign it to checkbox,if it isnt, explain more

Privesh Over a year ago

which would mean that i have to do this for all checkboxes, right?

Nika G. · Accepted Answer · 2011-07-04 12:53:35Z

0

if your problem is 55 checkboxes, thus 55 diff names to work/code with, switch to CheckBoxList for asp.net or CheckedListBox for winforms.

answered Jul 4, 2011 at 12:53

Nika G.

2,3941 gold badge17 silver badges18 bronze badges

Collectives™ on Stack Overflow

dynamic checkboxes

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related