Value from sql to textbox c#

Goran Bibic

8y888Learn iOS Programming

I need this result display to text box

select SUM(CAST(REPLACE(iznos_sa_pdv,'.', '.')AS decimal(18,2)))
from mp_kasa_lista
WHERE datum >= CONVERT(datetime, convert(varchar(10), GETDATE() ,120), 120) AND datum < DATEADD(day, 1, convert(datetime, convert(varchar(10), getdate(), 120), 120))
AND tip_placanja='Virman'

Result is 582,00

2 Replies

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

Goran Bibic8y ago
Solved
string sqlquery = ("select SUM(CAST(REPLACE(iznos_sa_pdv,'.', '.')AS decimal(18,2))) as ukupno from mp_kasa_lista WHERE datum >= CONVERT(datetime, convert(varchar(10), GETDATE(), 120), 120) AND datum < DATEADD(day, 1, convert(datetime, convert(varchar(10), getdate(), 120), 120))  AND tip_placanja = 'Virman'");

           using (SqlConnection con = new SqlConnection(cs))
           {

           SqlCommand command = new SqlCommand(sqlquery, con);
               con.Open();


               SqlDataReader sdr = command.ExecuteReader();
               if (sdr.Read())

               {
                    virmantextBox.Text = (sdr["ukupno"].ToString());
                  // virmantextBox.Text = (sdr.ToString());

               }
               sdr.Close();
           con.Close();

           }
Goran Bibic8y ago
Solution
private void virman()
       {

           string sqlquery = ("select SUM(CAST(REPLACE(iznos_sa_pdv,'.', '.')AS decimal(18,2))) from mp_kasa_lista WHERE datum >= CONVERT(datetime, convert(varchar(10), GETDATE(), 120), 120) AND datum < DATEADD(day, 1, convert(datetime, convert(varchar(10), getdate(), 120), 120))  AND tip_placanja = 'Virman'   ");

           using (SqlConnection con = new SqlConnection(cs))
           {

           SqlCommand command = new SqlCommand(sqlquery, con);
               con.Open();


               SqlDataReader sdr = command.ExecuteReader();

           virmantextBox.Text = sdr.ToString();
               sdr.Close();
           con.Close();

           }

       }
Error is in textbox is result :
System.Data.SqlClient.SqlDataReader