Goran Bibic

Goran Bibic

  • 480
  • 2.9k
  • 198.2k

Value from sql to textbox c#

May 19 2018 11:56 AM
I need this result display to text box
  1. select SUM(CAST(REPLACE(iznos_sa_pdv,'.''.')AS decimal(18,2)))  
  2. from mp_kasa_lista   
  3. WHERE datum >= CONVERT(datetime, convert(varchar(10), GETDATE() ,120), 120) AND datum < DATEADD(day, 1, convert(datetime, convert(varchar(10), getdate(), 120), 120))  
  4.   AND tip_placanja='Virman'               
 Result is 582,00

Answers (2)