Loading

Having trouble merging where clause and group by clause

Marvin kakuru

Below is the code am trying to use

string sql = ("select item, sum(dr) from ledger where companyid = '"+ textbox1.text+"' GROUP BY item");

2 Replies

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

Sachin Singh5y ago
your SQL seems correct
string sql = "select item, sum(dr) from ledger where companyid = @compId GROUP BY item";

SqlCommand cmd= new SqlCommand(sql,cs);
cmd.Parameters.AddWithValue("@compId",textbox1.Text);
con.Open();
SqlDataReader rdr=cmd.ExecuteReader();
Ganesan C5y ago
Hi,

What is the error? If more details then easy to solve issue.