Using ComboBox with DataTable in C#

madeinstein ,

Define the ComboBox with DataTable

//define DataTable

DataTable dt = new DataTable("dataTable");

dt.Columns.Add("Id", typeof(int));

dt.Columns.Add("Name", typeof(string));

//add DataRow

DataRow row = dt.NewRow();

row["Id"] = 1;

row["Name"] = "One";

dt.Rows.Add(row);

//assign to ComboBox

comboBox.DataSource = dt;

comboBox.DisplayMember = "Name";

comboBox.ValueMember = "Id";



Get Selected data from ComboBox



DataRow row = ((DataTable)comboBox.DataSource).Rows[comboBox.SelectedIndex];

int Id = (int)row["Id"];

string Name = (string)row["Name"];
  































Comments









  1. Anonymous21 February 2013 at 08:18
     good job
    ReplyDelete
  2. trimp4 May 2013 at 17:22
    Is it possible to give more than one display member in cmbboBox.DisplayMember like:

       cmbStaff.DisplayMember = string.Format("{0} {1} {2}","FirstName","MiddleName","LastName");
    ReplyDelete
  3. Michael Letourneau14 April 2021 at 19:46
    You must create an expression Column
                datatable.Columns.Add("FullName", typeof(string));
    datatable.Columns[12345].Expression = "FirstName + ' ' + MiddleName + ' ' + LastName";
    ReplyDelete











Post a Comment



















Popular posts from this blog










Tibco Rendezvous (tibrv) C# .Net example









madeinstein



,















This is an example of broadcast messaging using TIBCO Rendezvous .   You can find more information about queue, dispatcher, transport and other rendezvous concepts in the TIBCO Rendezvous® Concepts  pdf documentation.   Command Line:   Receiving messages   tibrvlisten –service <port> -network "<ip-address>" –daemon <port> "<subject>"    tibrvlisten –service <port> -network ";<multicast-ip-address>" –daemon <port> "<subject>"         tibrvlisten -service 7500 -network "192.168.xx.xxx" -daemon 7500 "ME.TEST"     tibrvlisten -service 7500 -network "192.168.xx.xxx" -daemon 7500 "ME.>"   Publishing messages   tibrvsend –service <port> -network "<ip-address>" –daemon <port> "<subject>" "<your-message>"   tibrvsend -service 7500 -network "192.168.xx.xxx" -daemon 7500 "ME.TEST" "He...








Read more










Parse XML to dynamic object in C#









madeinstein



,















<? xml version="1.0" encoding="utf-8" ?>  < contacts >    < contact  id = '1' >      < firstName > Michael </ firstName >      < lastName > Jordan </ lastName >      < age > 40 </ age >      < dob > 1965 </ dob >      < salary > 100.35 </ salary >    </ contact >    < contact  id = '2' >      < firstName > Scottie </ firstName >      < lastName > Pippen </ lastName >      < age > 38 </ age >      < dob > 1967 </ dob >      < salary > 55.28 </ salary >    </ contact >  </ contacts >   public  class  XmlToDynamic {   public  static  void  Parse(dynamic parent, XElement node)   {     if  (node.HasElements)     {       if  (node.Elements(node.Elements().First().Name.LocalName).Count() > 1)       {         //list          var item = new  ExpandoObject();         var list = new  List<dynamic...








Read more