如何将数据源绑定到标签控件

public string SqlConnection(string queryString)
{
    using (var conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["RBConnectionString"].ConnectionString))
    using (var cmd = conn.CreateCommand())
    {
        conn.Open();
        cmd.CommandText = queryString;
        using (var reader = cmd.ExecuteReader())
        {
            while (reader.Read())
            {
                // This will return the first result 
                // but there might be other
                return reader.GetString(0);
            }
        }
        return null;
    }
}

这也将确保在例外情况下,所有的一次性物品都被处理,并将正确地返回 SQLConnection 连接到连接池以便重用。

Text 标签属性:

lblTest.Text = SqlConnection("SELECT Description FROM RbSpecials WHERE Active=1");

使用 ExecuteReader ExecuteNonQuery

public void Sql_Connection(string queryString)
{
     using(SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings"RBConnectionString"].ConnectionString))
     {
        using(SqlCommand cmd = new SqlCommand(queryString, conn))
        {
           conn.Open();
           using(SqlDataReader rdr = cmd.ExecuteReader())
           {
               while(rdr.Read())
               {
                   lblDescription.Text = rdr.GetString(0); 
               }
           }
        }

     }
}

using (SqlConnection con = new SqlConnection(Connection_String))
{
   SqlCommand cmd = new SqlCommand("select * from Customers", con);
   cmd.CommandType = CommandType.StoredProcedure;
   SqlDataReader adpt = cmd.ExecureReader();
   if(rdr.Read())
    {
      lblName.Text = rdr[0].ToString();
    }
 }