Label9

64         private void label9_Click(object sender, EventArgs e)
65         {
66             this.Close();
67         }

50         private void textBox1_TextChanged(object sender, EventArgs e)
51         {
52             textBox2.Text = "";
53             SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=F:\Sem.4\C# Projects\College management system\CollegeManagementSystem\SchoolManagementSystem\school.mdf;Integrated Security=True;User Instance=True");
54
55             con.Open();
56             if (textBox1.Text != "")
57             {
58                 try
59                 {
60                     string getCust = "select name,standard,medium from student where std_id=" + Convert.ToInt32(textBox1.Text) + " ;"; // saving new custmer info
61
62                     SqlCommand cmd = new SqlCommand(getCust, con);
63                     SqlDataReader dr;
64                     dr = cmd.ExecuteReader();
65                     if (dr.Read())
66                     {
67                         label9.Text = dr.GetValue(0).ToString();
68                         label6.Text = dr.GetValue(1).ToString();
69                         label7.Text = dr.GetValue(2).ToString();
70                     }
71                     else
72                     {
73                         MessageBox.Show("Sorry '" + textBox1.Text + "' This Registration Id is Invalid, Please Insert Correct Id");
74                         textBox1.Text = "";
75                         textBox2.Text = "";
76                     }
77                 }
78                 catch (SqlException excep)
79                 {
80                     MessageBox.Show(excep.Message);
81                 }
82                 con.Close();
83             }
84         }

44         private void frm_prev_Load(object sender, EventArgs e)
45         {
46             label1.Text = "Name : " + Name1;
47             label2.Text = "Nickname : " + Nickname;
48             label3.Text = "Phone Number : " + PhoneNumber;
49             label4.Text = "Mobile Number : " + MobileNumber;
50             label5.Text = "Email Address : " + EmailAddress;
51             label6.Text = "Home Address : " + HomeAddress;
52             label7.Text = "Company : " + Company;
53             label8.Text = "Position : " + Position;
54             label9.Text = "Group : " + GroupName;
55             label10.Text = "Website : " + Website;
56             label11.Text = "Facebook Account : " + FacebookAccount;
57         }