how to fill combobox in c# windows application from database

Jyoti Jodha

cmd = new SqlCommand("insert into Additem(Product_Name,Description,Qty,Unit_Price,Tax) values(@Product_Name,@Description,@Qty,@Unit_Price,@Tax)", con);

con.Open();

cmd.Parameters.AddWithValue("@Product_Name", producttxt.Text);

cmd.Parameters.AddWithValue("@Description", destxt.Text);

cmd.Parameters.AddWithValue("@Qty", qtytxt.Text);

cmd.Parameters.AddWithValue("@Unit_Price", unitxt.Text);

cmd.Parameters.AddWithValue("@Tax", comboBoxtax);

//cmd.Parameters.AddWithValue("@Tax",comboBoxtax.GetItemText(comboBoxtax.SelectedItem));

cmd.ExecuteNonQuery();

con.Close();

MessageBox.Show("Record Inserted Successfully");

DisplayData();

ClearData();

9 Replies

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

Ramesh Palanivel9y ago
Accepted answer
Hi Jyoti,

Try this URL...

http://www.c-sharpcorner.com/UploadFile/009464/bind-combobox-in-window-application-using-C-Sharp/
Munesh Sharma9y ago
your question is not much clear , how to select record in gridview .. means

after assign the data in gridview ,you want to select any record from gridview and you want to show it somewhere ? or exactly what you what you want ,can eyou explore it ?
Jyoti Jodha9y ago
private void DisplayData()
{
dataGridView1.AutoGenerateColumns = false;
con.Open();
DataTable dt = new DataTable();
adapt = new SqlDataAdapter("select Tax_ID,Tax,percentage from Tax", con);
cmd.Parameters.AddWithValue("@Tax", this.txt_tax.Text.Trim());
cmd.Parameters.AddWithValue("@percentage", this.txt_per.Text.Trim());
cmd.ExecuteNonQuery();
adapt.Fill(dt);
dataGridView1.DataSource = dt;
con.Close();
}

How to show selected Records in gridview
Please tell me.....
Munesh Sharma9y ago
http://dotnet-munesh.blogspot.in/2014/04/link-combobox-with-database-in-window.html
Karthi Keyan9y ago
Hi Jodha,

There is a two ways to load the data's in combobox.

1. Using Datasource.

       Select your Required Data in Datatable. Example Product_Name. and load that datatable into your combobox.

       comboBoxtax.DataSource = dt; // DataTable Name
       comboBoxtax.DisplayMember = "Product_Name";
       comboBoxtax.SelectedIndex = -1; // Index of Selected Value. -1 means no value will display in combobox. if 0 first value will display.

2. Using Foreach.

Select your Required Data in Datatable. Example Product_Name. initial process is same. but next code will add Product_Name one by one in combobox.

foreach(DataRow dr in dt.Rows)
      {
           comboBoxtax.Items.Add(dr["Product_Name"]);
      }
comboBoxtax.SelectedIndex = -1;
Jyoti Jodha9y ago
Thanx Sir
Ranjeet Patra9y ago
Hi Jyoti,

You can use the below properties of Combobox to select the value of combox for inserting into database depending your requirement:

Combobox.Text

Combobox.SelectedItem

Combobox.SelectedValue
Combobox.SelectedIndex

Have a look at the link:

http://stackoverflow.com/questions/21552789/combobox-text-vs-combobox-selecteditem-vs-combobox-selectvalue

https://www.codeproject.com/Questions/379432/how-to-insert-data-from-combo-box-to-sql-database
Jyoti Jodha9y ago
how to select values insert in database use combobox

Hows this.....????
Ranjeet Patra9y ago
Hi Jyoti,

Have a look at below links:

https://www.codeproject.com/Articles/8597/Populate-data-from-database-in-a-ComboBox

http://csharp.net-informations.com/dataset/dataset-combobox.htm

http://www.thedevelopertips.com/DotNet/WindowsFormsCSharp/Fill-combobox-items-from-Database-windowsforms.aspx?id=8