hi see below SP:
Declare @dt datetime
set @dt=GETDATE()
select (select COUNT(*) from Message ) as CountMessage
,(select COUNT(*) from Estate_deposit) as Deposite
,(select COUNT(*) from Estate_request ) as request
,(select count(*) from Estate_Archive where datediff(day, @dt, Expiredate) <= 2) as Expiredate
and behind code
private void CountMessage()
{
using (SqlConnection conn = General.GetConnection())
{
using (SqlCommand _cmd = General.GetCommand("CountMessage", conn))
{
conn.Open();
SqlDataReader _dr = _cmd.ExecuteReader();
while (_dr.Read())
{
blsmsS.Text = toPersianNumber(_dr["CountMessage"].ToString());
Lblnew.Text = toPersianNumber(_dr["CountMessage"].ToString());
Lbldeposit.Text = toPersianNumber(_dr["Deposite"].ToString());
Lblrequest.Text = toPersianNumber(_dr["request"].ToString());
sarresid .Text = toPersianNumber(_dr["Expiredate"].ToString());
}
}
}
}
and I define image in page:
<asp:Image ID="Imgshow" runat="server" ImageUrl="~/Image/admin/gift.gif" CssClass="gift" Visible="false"></asp:Image>
now I want if countofmessage >0 ( I mean if in message table exist any row any rows) it make imgshow visible="true"
how I can do it?
Best regards
neda