代码之家 › 专栏 › 技术社区 › The Muffin Man

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

.net asp.net c#

1

The Muffin Man · 技术社区 · 16 年前

public void Sql_Connection(string queryString)
{
    SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["RBConnectionString"].ConnectionString);
    SqlCommand cmd = new SqlCommand(queryString, conn);
    conn.Open();
    cmd.ExecuteNonQuery();
    conn.Close();
}

我使用的查询:

从RbSpecials中选择Description,其中Active=1

3 回复 | 直到 13 年前

1

3

Darin Dimitrov 16 年前

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

2

1

Azhar 16 年前

使用 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); 
               }
           }
        }

     }
}

3

0

Amit Kumawat 10 年前

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