Loading

How to get Sum(value) between two dates using MySQL and CSharp?

How to get Sum(value) between two dates using MySQL and CSharp?

Jose Palmieri

4y1.3kLearn iOS Programming

I'am using the SQL bellow, MySQL and C#

string str = "Select Sum(value) from

where and date between (date1) and (date2)";

I need to get the result of this SQL on C#, how do I do that?

2 Replies

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

Gajendra Jangid4y ago
Hi, Use below codes

Sql
create proc usp_getTotal
    @date2 as date,
    @date2 as date
as
begin
    SELECT SUM(ISNULL(col, 0))
    FROM tableName
    WHERE date BETWEEN @date1 AND @date2
end
Muhammad Imran Ansari4y ago
Step-1:
Write a storeprocedure with data parameters at SQL side to calculate and get the sum of value. like:
ALTER PROCEDURE sp_getSum
    @fromDate AS DATE,
    @toDate AS DATE
AS
BEGIN
    SELECT SUM(ISNULL(valueCol, 0))
    FROM yourTable
    WHERE dateCol BETWEEN @fromDate AND @toDate
END
Step-2:
Call this store procedure in C# to get the result. like:
SqlConnection conn = new SqlConnection();
            conn.ConnectionString = "YourConnectionString"; // Add your SQL Connection String here
using (SqlCommand cmd = new SqlCommand("sp_getSum", conn))
{
        cmd.CommandType = CommandType.StoredProcedure;

        cmd.Parameters.AddWithValue("@fromDate", "2022-03-01");
        cmd.Parameters.AddWithValue("@toDate", "2022-03-10");

        if (conn.State != ConnectionState.Open)
                conn.Open();

        int sumVal = Convert.ToInt32(cmd.ExecuteScalar());
}