Dropdown Binding issue - C#

Question

0.00/5 (No votes)

See more:

Hi,

I have filled one dataset from sql query and that dataset returns the below values.

ID CID
3 7
8 466
23 566
11 700

Now I want to modify CID and after that ID and CID should be bind with Dropdown. Datavaluefield of dropdown would be the below ID's and Datatextfield would be below CID's.

ID CID
3 C0007
8 C0466
23 C0566
11 C0700

I have written the below code but it is not working fine as please check loop may be some issue in loop. Please cross check the below code and help asap.

C#

for (int i = 0; i < dset.Tables["Table"].Rows.Count; i++)
                {
                    foreach (DataRow myRow in dset.Tables["Table"].Rows)
                    {
                        int CCid;
                        CCid = (int)myRow["CID"];

                        string str = String.Format("C{0:0000}", CCid);

                        DataTable table = new DataTable("MyTable");

                        table.Columns.Add("id", typeof(int));
                        table.Columns.Add("name", typeof(string));

                        string[] names = { str };

                        DataRow dr;

                        for (int j = 0; j < dset.Tables["Table"].Rows.Count; j++)
                        {
                            dr = table.NewRow();

                            dr["id"] = j + 1;

                            dr["name"] = Convert.ToString(names[str[0]]);

                            table.Rows.Add(dr);
                        }

                        DataSet ds = new DataSet();

                        ds.Tables.Add(table);

                        ddlContract.DataSource = ds.Tables["MyTable"];
                        ddlContract.DataTextField = "name";
                        ddlContract.DataValueField = "id";
                        ddlContract.DataBind();
                    }
                }

Posted 31-May-12 12:03pm

vibsg

Updated 1-Jun-12 0:10am

v4

Add a Solution

Comments

Nelek 31-May-12 19:38pm

Code tags added.

You have described what you want to do but... What are the problems? A bit more info would be fine: "not working fine" is not very descriptive.

Please use "improve question" and give a brief description of the issues

vibsg 1-Jun-12 5:13am

Drop down is not binding with CID .t his is the issue. please help.

2 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)

jerome dela cruz · Answer 1 · 2012-05-31T13:32:00

Solution 1

Hi are you using the comboBox? If so, try the following code..

C#

ComboBox1.DisplayMember = "name";
ComboBox1.ValueMember = "id";
ComboBox1.DataSource =  ds.Tables["MyTable"];
ComboBox1.Databind();

Posted 31-May-12 13:32pm

jerome dela cruz

v2

Comments

vibsg 1-Jun-12 5:14am

No, I am usinf dropdown as this above code in c#. thanks.

bhaskarareddy 1-Jun-12 6:26am

this code is useful for win form application not for web application.

Jim Jos · Answer 2 · 2012-06-01T00:54:00

Why do you need three loops? You have loops within loops which is creating major problems for you...

C#

DataTable table = new DataTable("MyTable");
DataRow dr;
table.Columns.Add("id", typeof(int));
table.Columns.Add("name", typeof(string));
 

foreach (DataRow myRow in dset.Tables["Table"].Rows)
                    {
                        int CCid;
                        CCid = (int)myRow["CID"];
 
                        string str = String.Format("C{0:0000}", CCid);
                        string[] names = { str };
                        dr = table.NewRow();
                        dr["id"] = j + 1;
                        dr["name"] = Convert.ToString(names[str[0]]);
                        table.Rows.Add(dr);
                        }
 
                 ds.Tables.Add(table);
                 ddlContract.DataSource = ds.Tables["MyTable"];
                 ddlContract.DataTextField = "name";
                 ddlContract.DataValueField = "id";
                 ddlContract.DataBind();

Still it's no way near effecient code!! but for educational purposes it's ok..