How to get data in combobox from database?

roy himanshu

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

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mageshwaran R6y ago
Hi,
Try this Code:
while (reader.Read())

{

for (var i = 0; i < reader.count; i++)
{
  comboBox1.Items.Add(reader[i].ToString());
}
}
Kirtan Patel17y ago
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 Kumar17y ago
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 Chakraborty17y ago
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 himanshu17y ago
hi,
iam not able to understand.plz give me clearly
thanx
Niradhip Chakraborty17y ago
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 Bar17y ago
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();
}