Click here to Skip to main content
12,077,911 members (47,512 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: SQL-server-2005 .NET3.5 C# .NET , +
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 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
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web04 | 2.8.160212.1 | Last Updated 7 Apr 2013
Copyright © CodeProject, 1999-2016
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