how to selected combo box item name C#

Jyoti Jodha

how to selected combobox item name show in gridview and ID save in database

and same work on Update Queery in windows application c#

// Insert Queery

cmd = new SqlCommand("insert into Product(Name,Description,Tax_ID,Unit_ID) values(@Name,@Description,@Tax_ID,@Unit_ID)", con);

con.Open();

cmd.Parameters.AddWithValue("@Name", txtName.Text);

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

cmd.Parameters.AddWithValue("@Tax_ID", comboBoxtax.Text);

cmd.Parameters.AddWithValue("@Unit_ID", comboBoxunit.Text);

// Update Queery

cmd = new SqlCommand("update Product set Name=@Name,Description=@Description,Tax_ID=@Tax_ID,Unit_ID=@Unit_ID where Product_ID=@id", con);

con.Open();

cmd.Parameters.AddWithValue("@id", Product_ID);

cmd.Parameters.AddWithValue("@Name", txtName.Text);

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

cmd.Parameters.AddWithValue("@Tax_ID", comboBoxtax.Text);

cmd.Parameters.AddWithValue("@Unit_ID", comboBoxunit.Text);

4 Replies

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

Rafnas T P9y ago
Accepted answer
no, I said when you are saving or updating time you can use instead of .Text you can use
.SelectedValue for saving Id

To show in grid you have change your select query, you have to join with those id tables than you have to select what you need
Bhuvanesh Mohankumar9y ago
If you are really confused with what to use where, then use the debug points and assign the temparavary variable and read the values and find the difference, you will get clear idea of which properties to use where its optimum.

1) Debug - Break Points: Try to use debug points and execute the application and see what happens, this is the first step for a developer.
Jyoti Jodha9y ago
When We Use .SelectedValue
Gridview Show .SelectedValue ID.....???
Rafnas T P9y ago
while saving or updating instead of comboBoxtax.Text you can use comboBoxtax.SelectedValue