如何在标签C＃中提供数据 [英] How to give out data in a lable C#

问题描述

你好，我试图用标签来提供我的数据，但我不知道如何做到这一点。我相信这不是很难...

 connectinString =Data Source =+ fileName +; max database size = 256 ; 
 conn = new SqlCeConnection（connectinString）; 
 cmd = new SqlCeCommand（SELECT COUNT（*）FROM Pigeons，conn）; 
 conn.Open（）; 
< code> MessageBox.Show< / code>（cmd.ExecuteScalar（）。ToString（））; 
 conn.Close（）; 
 

现在它显示在消息框中，但我怎样才能将它放入标签？

 private void label1_Click（object sender，EventArgs e）
 {
 
} 

< br $> b $ b

我的尝试：



我在互联网上寻找解决方案，但我找不到任何东西......

解决方案

试试这个：

 connectinString = < span class =code-string> 数据源= + fileName +  ; max database size = 256; 
 使用（conn =  new  SqlCeConnection（connectinString））
 {
 使用（md =  new  SqlCeCommand（  SELECT COUNT（*）FROM Pigeons，conn））
 {
 conn.Open（）; 
 label1.Text = cmd.ExecuteScalar（）。ToString（）; 
} 
} 

 label1.Text = cmd.ExecuteScalar（）。ToString（）; 

Hello, I am trying to give out my data in a lable but i have no clue how to do this. I am sure it isnt very difficult...

connectinString = "Data Source = " + fileName + ";max database size=256";
           conn = new SqlCeConnection(connectinString);
           cmd = new SqlCeCommand("SELECT COUNT(*) FROM Pigeons", conn);
           conn.Open();
           <code>MessageBox.Show</code>(cmd.ExecuteScalar().ToString());
           conn.Close();

Now it is shown in a Message Box, but how can i put it into a lable?

private void label1_Click(object sender, EventArgs e)
        {
            
        }

What I have tried:

I looked for solution in the internet, but i couldn't find anything...

解决方案

Try this:

connectinString = "Data Source = " + fileName + ";max database size=256";
using (conn = new SqlCeConnection(connectinString))
    {
    using (md = new SqlCeCommand("SELECT COUNT(*) FROM Pigeons", conn))
        {
        conn.Open();
        label1.Text = cmd.ExecuteScalar().ToString();
        }
    }

label1.Text = cmd.ExecuteScalar().ToString();

这篇关于如何在标签C＃中提供数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！