How to get value from sql server

dhoni kholi

6y789.NET

string Bill;
protected void Page_Load(object sender, EventArgs e)
{
Bill = "22-01-2020 ";
if (!IsPostBack)
{
cash();
}
}
protected void cash()
{
string query = "select SUM((CASE WHEN ISNUMERIC([Total])=1 THEN CONVERT(MONEY,[Total]) ELSE 0 END))AS [Amount] from Bill where Bdate = CONVERT(DATETIME, '" + Bill + "', 105) and Btype ='Cash'";
con.Open();
cmd = new SqlCommand(query, con);
SqlDataReader dr;
dr = cmd.ExecuteReader();
if (dr.Read())
{
string amount = dr["Amount"].ToString();
lblCash.Text = amount.ToString();
con.Close();
}
con.Close();
}

This query value is Null,

How to i get Sum value from sql

Thanks all

5 Replies

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

dhoni kholi6y ago
Thanks For Your Answers

I find alternative query

Thanks For ur Support
Guest User6y ago
If you remove the where, do you get a value then?

If so, check your columns values.
Rajanikant Hawaldar6y ago
Hello Dhoni Kohli, Bill = "22-01-2020 " this contains whitespace so only output is not coming
dhoni kholi6y ago
The value is Null
Guest User6y ago
If you execute this exact query in SSMS, does it return a value?