data binding in combobox

Question

0.00/5 (No votes)

See more:

my function is :--

C#

public static int varBool;
public static void fillCmbo(ComboBox cmb, string str)
{
    DataSet ds = new DataSet();
    ds = Connector.ExecuteDataset(mainCon.cn, CommandType.Text, str);
    varBool = 0;
    cmb.DataSource = ds.Tables[0];
    cmb.ValueMember = ds.Tables[0].Columns[0].ColumnName;
    cmb.DisplayMember = ds.Tables[0].Columns[1].ColumnName;
    cmb.SelectedIndex =-1;
    varBool = 1;
}

This function work properly but DataBind from 0 index of ComboBox and I try to insert a "<Select Item >" Word in 0 Index after DataBind.

Please help.

Thanks in advance

Posted 26-Jan-11 7:22am

raj_raje

Updated 26-Jan-11 7:42am

Henry Minute

v2

Add a Solution

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)

Henry Minute · Answer 1 · 2011-01-26T07:59:00

You haven't shown your SELECT statement so I cannot use your column names and I do not know how many columns you are retrieving, so I will offer a couple of alternatives.

Change your SELECT to something like:

SQL

SELECT "Select", "<Select Item>"
UNION
SELECT valueMemberColumn, displayMemberColumn FROM yourDB

Or
After you have filled the DataSet but before you bind it to the ComboBox, insert a new row into the table with your <Select Item> in the appropriate column.

Theingi Win · Answer 2 · 2011-01-26T16:26:00

You should try the following code,

C#

public static int varBool;
      public static void fillCmbo(ComboBox cmb, string str)
      {
          DataSet ds = new DataSet();
          ds = Connector.ExecuteDataset(mainCon.cn, CommandType.Text, str);
          varBool = 0;
                DataRow dr = ds.Tables[0].NewRow();
                dr[1] = "-Select-";
                dr[0] = "-1";
                ds.Tables[0].Rows.InsertAt(dr, 0);

                if (ds != null)
                {
                    if (ds.Tables[0].Rows.Count > 0)
                    {
                        
                        cmb.DataSource = ds.Tables[0].DefaultView;
                        cmb.ValueMember = ds.Tables[0].Columns[0].ColumnName;
                        cmb.DisplayMember = ds.Tables[0].Columns[1].ColumnName;
                    }
              }
       
      }

Best Regards,
Theingi Win

data binding in combobox

2 solutions

Solution 1

Solution 3

Add your solution here

Preview 0