Share via

whene table oper or Main Oper cat sum error format please i want check total amount i mean if amount in Oper null And amount in MainOper is 700 sum 700+0=700 add gift 100

Hussein Ali 1 Reputation point
2022-12-03T08:23:28.237+00:00

dbs.Close

ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
3,598 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
11,487 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Viorel 121.6K Reputation points
    2022-12-03T10:14:12.2+00:00

    Try adding COALESCE to your SQL commands, for example: select COALESCE(Sum(amount_Gift), 0) from Oper....

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.