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 + "\""); } } }

Enter values into combobox from database

Answers (8)