Value from sql to textbox c#

Question

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

Goran Bibic · Answer

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 ); 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 Bibic · Answer

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 ); 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

Value from sql to textbox c#

Answers (2)