getting output from sql command in c#

[olaleyeoladejo]

i'm working on a project and the only problem is that i want to sum a prticular column and put the out put on a label using sqlreader but instead of the value i get 'System.Data.Sq lClient.SqlData Reader' on the label

THE PROGRAM

SqlDataReader da = null;
                SqlCommand A = new SqlCommand("Select sum(amount) from transactions where type_of_transaction like '%" + Search + "%'", conn2);
                A.ExecuteNonQuery();
                
                da = A.ExecuteReader();
                da.Read();
                sum.Text = da.ToString();
                
                conn2.Close();

i will really appreciate ur help

[r035198x]

Do not use ExecuteNonQuery when you are executing a query. See the last part of this article on how to use ExecuteScalar to get your results.
Also you are setting the reader itself to the the label's text rather than the reader's results.

[olaleyeoladejo]

so how do i set the reader's result to the label

[r035198x]

Something like

cmd.CommandText = "SELECT COUNT(*) FROM tableName";
 Int32 count = (Int32) cmd.ExecuteScalar();

You then set the value count to be your label's text.

[olaleyeoladejo]

thanks it's working now