18-02-13, 11:27 AM
[HTML]
(Dim Sum As New OleDbCommand("select isnull(sum(profit-disacount),0) as TotalAmount from sales", Cn)
Dim TotalNo as Long = sum.ExecuteReader
if Totalno>0 then
you code
else
Msg("Total amount is Zeroo ")
باستخدام جملة Isnull فى جملة الاستعلام
[/HTML]
(Dim Sum As New OleDbCommand("select isnull(sum(profit-disacount),0) as TotalAmount from sales", Cn)
Dim TotalNo as Long = sum.ExecuteReader
if Totalno>0 then
you code
else
Msg("Total amount is Zeroo ")
باستخدام جملة Isnull فى جملة الاستعلام
[/HTML]