Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
hello
i want to display id in combox and their value (means its name) in textbox
for that purpose i did bellow code..
 
 string Query = "select id, name from LateFee";
            cmd = new SqlCommand(Query, con);
            
                //con.Open();

                dr = cmd.ExecuteReader();
                DataTable dt = new DataTable();
                dt.Columns.Add("id", typeof(string));
                //dt.Columns.Add("name", typeof(string));
                dt.Load(dr);
                comboBox1.ValueMember = "id";
                comboBox1.DisplayMember = "id";
               
                comboBox1.DataSource = dt;
                binding = new Binding("Text", comboBox1, "Text");
                textBox1.DataBindings.Add(binding);
 
but what is happing that in combox when i select id,in text box id is only appear but i want in textbox name should appear.
what should i do???
Posted 7-Apr-13 2:59am
Arifa S508
Edited 7-Apr-13 3:13am
v2

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

You need to change a few things,
 
1)
//dt.Columns.Add("name", typeof(string));
<< uncomment that out.
2)
comboBox1.ValueMember = "id";
should be
comboBox1.ValueMember = "name";
 
3)I think you need to change the binding from:
new Binding("Text", comboBox1, "Text");
to:
new Binding("Text", comboBox1, "SelectedValue");
  Permalink  
v2
Comments
Member 9823122 at 7-Apr-13 8:27am
   
yes thanks now it is working properly ...

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

  Print Answers RSS
0 OriginalGriff 330
1 Sergey Alexandrovich Kryukov 279
2 BillWoodruff 245
3 Afzaal Ahmad Zeeshan 215
4 CPallini 205
0 OriginalGriff 5,635
1 DamithSL 4,496
2 Maciej Los 3,942
3 Kornfeld Eliyahu Peter 3,480
4 Sergey Alexandrovich Kryukov 3,180


Advertise | Privacy | Mobile
Web03 | 2.8.141216.1 | Last Updated 7 Apr 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100