label 绑定数据

label 绑定数据

 

本文转自http://archive.cnblogs.com/a/1631188/

SqlCommand comm;
    SqlConnection conn;
    SqlDataReader dr;

   string sonid=Request.QueryString["sonid"].ToString();
    //数据库链接语句

conn = new SqlConnection("Integrated Security=SSPI;Persist SecurityInfo=False;Initial   Catalog=xigua;Data Source=JPLS-5");
    conn.Open();
    string sql = "select * from soncity where sonid =" + Convert.ToInt32(sonid);
    comm = new SqlCommand(sql, conn);
    dr = comm.ExecuteReader();
    dr.Read();
    lbtel.Text = dr.GetValue(4).ToString();