get data from database

Question

how to get a specific colum value from database ..with the combobox selction ..in window application form

Arul R · Answer

Kindly refer the below links, Hope this will solve your problem. http://www.codeproject.com/Questions/342593/How-we-display-database-table-one-column-values-in http://www.dreamincode.net/forums/topic/145973-fill-data-from-database-in-the-combobox/ http://www.codeproject.com/Articles/8597/Populate-data-from-database-in-a-ComboBox http://csharp.net-informations.com/dataset/dataset-combobox.htm http://dotnetsridhar.blogspot.in/2012/04/binding-combobox-in-windows.html Let me know for any thing more.... If your problem solved means kindly Accept my answer

anuj · Answer

my table name is customer.. and customer table colum name is id int, name varchar(20), and i bind the combobox with tha customer table ... i want id value from cutomer table with the selection of combobox try { con.Open(); SqlCommand cmd = new SqlCommand("select id from customer where Name ='" +comboBox1.SelectedValue + "'", con); int anuj1 = Convert.ToInt32(cmd.ExecuteScalar()); con.Close(); if (anuj1 > 0) { txtid.Text = Convert.ToString(anuj1); } } catch { }

Manas Mohapatra · Answer

Are you getting any exception after executing the code.

Ranjit Powar · Answer

There is any error in your query?

anuj · Answer

SqlCommand cmd = new SqlCommand("select id from customer where Name ='" +comboBox1.SelectedValue + "'", con); int anuj1 = Convert.ToInt32(cmd.ExecuteScalar()); i want id value from datatabel customer..

Rajeesh Menoth · Answer

Hi, 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 + "\""); } } } Reference : http://www.codeproject.com/Questions/342593/How-we-display-database-table-one-column-values-in