How to get data in combobox from database?

Question

hi, How to get data in to ComboBox from Data Base when form is load?Iam working on windows application in C#.so i want C# codeing?plz help me. is it possible?PLZ Tell me. Himanshu

Kirtan Patel · Answer

Hi Friend you can do it Like Below in Which i Have Taken One Table Users ( Username , Password) Now if i want to Fill ComboBox With Usernames then I can Code it Like Below dont forget to mark " Do you like answer " it will give me some credits :) private void Form1_Load( object sender, EventArgs e) { SqlConnection con = new SqlConnection ( @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True" ); con.Open(); comm = new SqlCommand ( "Select Username From Users" , con); SqlDataReader reader = comm.ExecuteReader(); while (reader.Read()) { comboBox1.Items.Add(reader[0].ToString()); } }

Naveen Kumar · Answer

hi create the connection to the database sqlconnection con=new sqlconnection(//to do:enter the database credentials); create the sql query you need to get string query="select * from table"; create the sqladapter from the query; dataadapter da=new sqldataadapter(query) create the dataset dataset ds=new dataset();; da.fill(ds);// fills the dataset the above code is to get the data from the datbase.once the dataset is ready now it is easy to bind with the combobox. combobox1.datasource=ds; combobox1.displaymember=ds.tables[0].coloumn0;// the coloumn data which the user need to be viewed . combobox1.valuemember=ds.tables[0].coloumn1;// the coloumn data which the user need to be used as reference.

Niradhip Chakraborty · Answer

Its very simple I am getting all the values from database and using datareader I am reading the value and inserting in combobox. The syntax will be same for you. all you need to do is change the sql statement and combox Id

roy himanshu · Answer

hi, iam not able to understand.plz give me clearly thanx

Niradhip Chakraborty · Answer

SqlConnection sqlCon = null; sqlCon = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"].ToString()); SqlCommand sqlCmd = new SqlCommand(); SqlDataAdapter adpData = null; SqlDataReader sdrData = null; sqlCon.Open(); string strSQL = "SELECT * from BoothTypes"; sqlCmd.CommandText = strSQL; sdrData = sqlCmd.ExecuteReader(); if (sdrData.HasRows) { while (sdrData.Read()) { cboBoothtype.Items.Add(new ListItem(sdrData["btp_txt_BoothType"].ToString(), sdrData["btp_txt_BoothId"].ToString())); } } sdrBoothTypes.Close(); sqlCon.Close(); sqlCon = null;

Roei Bar · Answer

Well its basically another datatype here is an howto code: void FillComcoBox() { DataTable dt = new DataTable(); String strconn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\Power\Desktop\db.mdb" ; OleDbConnection conn; OleDbDataAdapter da; try { conn= new OleDbConnection(strconn); da= new OleDbDataAdapter( "Select * from Positions" ,conn); dt.Clear(); da.Fill(dt); conn.Close(); this .cbPositions.DataSource =dt; this .cbPositions.DisplayMember = "Position" ; this .cbPositions.ValueMember= "ID" ; } catch ( Exception ex) { MessageBox.Show(ex.Message); } } private void frm_Load( object sender, EventArgs e) { FillComcoBox(); }

Mageshwaran R · Answer

Hi, Try this Code: while (reader.Read()) { for (var i = 0; i { comboBox1.Items.Add(reader[i].ToString()); } }