从SQL到文本框C＃的显示值 [英] Display value from SQL to textbox C#

问题描述

我需要将结果显示到文本框



我尝试了什么：

I nee to display result to textbox

What I have tried:

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'   

推荐答案

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

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

           }

这篇关于从SQL到文本框C＃的显示值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！