dynamically populate check boxes

Question

0.00/5 (No votes)

See more:

Hello All

I recently been tasked with rewriting my borland 2006 c++ into c#. I have drawn the checkboxes and is 55 or so checkboxes. The checboxes ought to be linked to the 11g database and they get their values (names, labels, checked or unchecked) from the database on a remote server. DOes anyone have any idea how i could do this. I am connecting to an oracle database and i have allready:

C#

using Oracle.DataAccess.Client;
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();
            
string sql = "SELECT PROGRAM_FIELD,DBFIELD, ACTIVE, S.PROGRAM_LABEL FROM GENDBA.SUPTALLYACTIVITIESCONFIG S where active = 'Y' and gcos_schema = '" + frmSchema.schema +"'";

            OracleCommand cmd = new OracleCommand(sql, conn);
            cmd.CommandType = CommandType.Text;
            OracleDataReader dr = cmd.ExecuteReader();
            dr.Read();

after the dr I'm sort of stuck. I appreciate any help you could provide.

ps: as a matter of interest the schema has 4 different schemas and each schema has different values for the same checkbox. in total we have 189 rows combining all 4 schemas.

Thank you in advance

Posted 5-Jul-11 1:25am

Privesh

Updated 5-Jul-11 1:31am

Tarun.K.S

v2

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Syed Salman Raza Zaidi · Answer 1 · 2011-07-05T01:32:00

Solution 1

Its better to use XML for populating controls dynamically
How ever with Oracle you can do it
like

chkbox1.checked = dr["name"].value

Posted 5-Jul-11 1:32am

Syed Salman Raza Zaidi

Privesh · Answer 2 · 2011-07-05T01:35:00

Solution 2

does this mean that i will have to do this for all checkboxes?

Posted 5-Jul-11 1:35am

Privesh

Comments

Syed Salman Raza Zaidi 5-Jul-11 7:40am

yes

Syed Salman Raza Zaidi · Answer 3 · 2011-07-05T01:38:00

Here's the sample,i want to populate a checkbox value according to Gridview's selected row's 9th cell value so i did this ===>

string valuechk = dataGridView1.CurrentRow.Cells[9].Value.ToString ();
              bool chkvalue = Convert.ToBoolean(valuechk);

              if(chkvalue ==false)
                   assignchk.Checked = false;//check box value assigning
               else
                   assignchk.Checked = true;

Now make your code as per your requirementHeres