querry returning zero value even though data is present in data base using asp.net with c#

charan sekhar

16y2.9k.NET

hi iam usin asp.net with c#
querry is returning zero value even though it is returning session value and data is present in data base
can you correct my code which helps me

 SqlCommand cmdallltransactions = new SqlCommand("SELECT  SUM(Amount) FROM   AllTransactions WHERE  TransDate BETWEEN '"+ txtfrom.Text +"' and '" + txtto.Text + "' and  (TransCode <> 0) and  BranchKey=" + Convert.ToInt32(Session["BranchKey"]) + " GROUP by  BranchKey", con);
con.Open();
       txttotal.Text =Convert.ToString(Convert.ToInt64(cmdallltransactions.ExecuteScalar()));
        con.Close();

1 Reply

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

Marimuthu Arigovindasamy16y ago
I couldn't find any pbm in ur code.
Can u pls assign ur query into string variable and get the output of variable and run it in ur SQL window for the SQL query output.
string query = "SELECT SUM(Amount) FROM AllTransactions WHERE TransDate BETWEEN '"+ txtfrom.Text +"' and '" + txtto.Text + "' and (TransCode <> 0) and BranchKey=" + Convert.ToInt32(Session["BranchKey"]) + " GROUP by BranchKey"

There may be a problem with DB column timestamp issue (For TransDate column).
0