IF no have value (NULL), need to set 0.00 SQL

Goran Bibic

8y914Learn iOS Programming

Question:

If is value NULL, need to put value 0 in textbox

Some help?

SELECT SUM(isnull(cast(REPLACE(TRY_CONVERT(int,TRY_CONVERT(float, iznos_bpdv),1), '#,0.00','0')AS decimal(10,2)),0.00)) as UKUPNObpdv
from mp_racun_roba
where tip_robe = 'Usluge (Generalno)' and id_fakture=105

5 Replies

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

Ruchi Sharavat8y ago
Accepted answer
SO, If your query is good than modify the code like this to check null and blank:
SqlCommand command = new SqlCommand(sqlquery, con2);
            con2.Open();
            SqlDataReader sdr = command.ExecuteReader();

            if (sdr.Read())
            // if (sdr.HasRows)
            {
  if(sdr["UKUPNObpdv"] !=null && sdr["UKUPNObpdv"] !=DBNull.Value && !String.IsNullOrEmpty(sdr["UKUPNObpdv"].ToString()))

{
                usluga_bez_pdvTextBox.Text = sdr["UKUPNObpdv"].ToString();
}
else
{
usluga_bez_pdvTextBox.Text ="0.00";
}
                usluga_pdvTextBox.Text = sdr["UKUPNOpdv"].ToString();
                usluga_sa_pdvTextBox.Text = sdr["UKUPNOsapdv"].ToString();

            }

            else


            {

                usluga_bez_pdvTextBox.Text = "0.00";
                usluga_pdvTextBox.Text = "0.00";
                usluga_sa_pdvTextBox.Text = "0.00";

            }
con2.close();
Goran Bibic8y ago
Ruchi Sharavat

Error //dt//

if (String.IsNullOrEmpty(Convert.ToString(dt.Rows[0]["UKUPNObpdv"])))
Ruchi Sharavat8y ago
Hi Goran, Try this query:
SELECT SUM(isnull(cast(REPLACE(iznos_bpdv, '#,0.00','0') AS decimal(10,2)),0.00)) as UKUPNObpdv
from mp_racun_roba
where tip_robe = 'Usluge (Generalno)' and id_fakture=105 is null
OR in code you may try:
if(String.IsNullOrEmpty(Convert.ToString(dt.Rows[0]["UKUPNObpdv"])))
{
  txtUKUPNObpdy.Text = "0.00";
}else{
  txtUKUPNObpdy.Text = dt.Rows[0]["UKUPNObpdv"];
}
Goran Bibic8y ago
I try this, reading is ok, but if is value null noting hapend
SqlCommand command = new SqlCommand(sqlquery, con2);
            con2.Open();
            SqlDataReader sdr = command.ExecuteReader();

            if (sdr.Read())
            // if (sdr.HasRows)
            {

                usluga_bez_pdvTextBox.Text = sdr["UKUPNObpdv"].ToString();
                usluga_pdvTextBox.Text = sdr["UKUPNOpdv"].ToString();
                usluga_sa_pdvTextBox.Text = sdr["UKUPNOsapdv"].ToString();

            }

            else


            {

                usluga_bez_pdvTextBox.Text = "0.00";
                usluga_pdvTextBox.Text = "0.00";
                usluga_sa_pdvTextBox.Text = "0.00";

            }
con2.close();
Suraj Kumar8y ago
Hello Goran,
You can do it in the C# code as shown below
if(Convert.ToString(dt.Rows[0]["UKUPNObpdv"])=="")
{
  txtUKUPNObpdy.Text = "0.00";
}else{
  txtUKUPNObpdy.Text = dt.Rows[0]["UKUPNObpdv"];
}

IF no have value (NULL), need to set 0.00 SQL

Ruchi Sharavat