Thursday, November 28, 2013

retrieving data from database to lables

  private void button3_Click(object sender, EventArgs e)
        {
            con.Open();
            SqlCommand cmd9 = new SqlCommand("select * from sample", con);
            SqlDataReader dr = cmd9.ExecuteReader();
            while (dr.Read())
            {
                textBox3.Text = dr["name"].ToString();
                textBox4.Text = dr["email"].ToString();
            }
        }

No comments:

Post a Comment