how to load sum of value while select from combo box item c# WinForms

Luv L

3y957C#

private void mComBale_SelectedIndexChanged(object sender, EventArgs e)
{
    try
    {
       
        string query1 = "SELECT baleno, SUM(mtrs) FROM tbChallan GROUP BY baleno'" + mComBale.SelectedItem.ToString() + "'";
        cm = new SqlCommand(query1, con);
        con.Open();
        dr = cm.ExecuteReader();
        while (dr.Read())
        {
            rsLblBaleTotal.Text = dr["baleno"].ToString();
        }
        dr.Close();
        con.Close();
    }
    catch(Exception ex)
    {
       MessageBox.Show(ex.Message);
    }
}

syntax is I write correctly. but when I select the item from combobox then I need sum of mtrs from baleno

any correction in code??

pls help

2 Replies

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

Rajkiran Swain3y ago
Accepted answer
```
string query1 = "SELECT baleno, SUM(mtrs) AS totalMtrs FROM tbChallan WHERE baleno='" + mComBale.SelectedItem.ToString() + "' GROUP BY baleno";
```
There is an error in your SQL query. The GROUP BY clause is missing the column name. The corrected query should be like above query:
```
rsLblBaleTotal.Text = dr["totalMtrs"].ToString();
```
Also, you need to assign the value of the calculated sum to the label control. So, the line inside the while loop should be:
Luv L3y ago
Many Thanks.