fetching the label text from database in C#

Posted by Yilmaz Paçariz on Stack Overflow See other posts from Stack Overflow or by Yilmaz Paçariz
Published on 2012-10-01T15:36:39Z Indexed on 2012/10/01 15:37 UTC
Read the original article Hit count: 188

Filed under:
 private void button5_Click(object sender, EventArgs e)
        {
            SqlConnection conn = new SqlConnection("Data Source=MAZI-PC\\PROJECTACC;Initial Catalog=programDB;Integrated Security=True");
            SqlCommand cmd = new SqlCommand("select label_sh from label_text where label_form='2' and label_form_labelID='1'", conn);
            conn.Open();
            label1.Text = cmd.ExecuteReader().ToString();
            conn.Close();

            SqlConnection conn1 = new SqlConnection("Data Source=MAZI-PC\\PROJECTACC;Initial Catalog=programDB;Integrated Security=True");
            SqlCommand cmd1 = new SqlCommand("select label_sh from label_text where label_form='2' and label_form_labelID='2'", conn1);
            conn1.Open();
            label2.Text = cmd1.ExecuteReader().ToString();
            conn1.Close();

            SqlConnection conn2 = new SqlConnection("Data Source=MAZI-PC\\PROJECTACC;Initial Catalog=programDB;Integrated Security=True");
            SqlCommand cmd2 = new SqlCommand("select label_sh from label_text where label_form='2' and label_form_labelID='3'", conn2);
            conn2.Open();
            label3.Text = cmd2.ExecuteReader().ToString();
            conn2.Close();
        }

I am developing a small project in C#... Using Visiual Studio 2010... I want to fetch the label texts from database in order to change the user interface language with a button... I wrote this code but there is a problem in SQLDATAREADER

in label text parts it shows System.Data.SqlClient.SqlDataReader

I cant fix, could you help me?

© Stack Overflow or respective owner

Related posts about c#