Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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();
- }
- label3.Text = (string) cmd2.ExecuteScalar();
Add Comment
Please, Sign In to add comment