Enter values into combobox from database

Question

Hoe to enter values into combobox from database?

Sambhav Jain · Answer

Cool it worked thanks Buddy !

Arshad · Answer

Hi pass this query Like this select '['+CAST(ID As varchar(20))+'] '+Name As FullDetails from Emp I think It should Work Thanks Regards Khan

Sambhav Jain · Answer

Its giving an SqlException stating Conversion failed when converting the varchar value '[' to data type int

Arshad · Answer

Hi while fetching the Data just Pass the Querry Like that Select ID('['+ID+']'+EnpName) As FullDeatils form Emp Then while DataBinding just Give like that combobox.Displaymember =  FullDeatils ; combobox.Valuemember = ID; Thanks Regards Khan

Sambhav Jain · Answer

One small doubt If I want to display both the name column and its id together what should you think I should do for example combobox.Displaymember = Name; combobox.Valuemember = Name; combobox.Displaymember = userID; combobox.Valuemember = userID; now to display userId together with name like this what shoud i do ?? sam[1003] ran[2003]

Fernando Soto · Answer

Not a problem glad to help. ;=)

Sambhav Jain · Answer

Thanks a lot it worked :)

Fernando Soto · Answer

Hi Sambhav; Here is some sample code I put together using the Northwind database and filling a combo box with data from the Customers table and also storing the primary key so that when you select a different item from the combo box a message box pops up and show the primary key for the item selected. Fernando using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace WindowsApplication44 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } SqlDataAdapter da; DataSet ds = new DataSet(); private void Form1_Load(object sender EventArgs e) { // Build the Connection String and create a SQL Connection object String cnnStr = Data Source = localhost; Initial Catalog = Northwind; Integrated Security = SSPI; SqlConnection cnn = new SqlConnection(cnnStr); // Create a SQL Command object from the connection object and setup the SELECT command SqlCommand cmd = cnn.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = SELECT * FROM Customers; // Create the data adapter to use to get the data and handle connecting to the DB da = new SqlDataAdapter(cmd); // Get the data from the database. I am using the Northwind database the customers table da.Fill(ds Customers); // Disconnect the event handler to handle the comboBox1_SelectedIndexChanged event // while the combo box is being populated otherwise it will fire a couple of times // before you are ready to handle them. this.comboBox1.SelectedIndexChanged -= new System.EventHandler(this.comboBox1_SelectedIndexChanged); // Connect the cobo box to the data source from where the data is comming from // In this case the Customers data table in the dataset. comboBox1.DataSource = ds.Tables[Customers]; // Tell the combo box what collumn to display to the user comboBox1.DisplayMember = CompanyName; // Tell the combo box what collumn to use with the displayed value value is not displayed comboBox1.ValueMember = CustomerID; // Restored the event handler this.comboBox1.SelectedIndexChanged += new System.EventHandler(this.comboBox1_SelectedIndexChanged); } private void comboBox1_SelectedIndexChanged(object sender EventArgs e) { // When the user clicks on a item in the combo box ist primary key will be displayed. MessageBox.Show(Customer Primary Key is \ + comboBox1.SelectedValue + \); } } }