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