private void SendEmail_Click(object sender, EventArgs e)
        {
            Random random = new Random();

            activationCode = random.Next(1000, 9999).ToString();

            con.Open();
            string         query = "insert into Registration (Fullname,Email,PhoneNo,Address,Category,Username,Password,ActivationCode,status) values ('" + Fname.Text + "','" + EmailT.Text + "','" + PhoneNoT.Text + "','" + AddressT.Text + "','" + CategoryT.Text + "','" + UsernameT.Text + "','" + PasswordT.Text + "','" + activationCode + "','Unverified')";
            SqlDataAdapter SDA   = new SqlDataAdapter(query, con);

            SDA.SelectCommand.ExecuteNonQuery();
            String         query1 = "Select Id from Registration where Username ='******' ";
            SqlDataAdapter SDB    = new SqlDataAdapter(query1, con);

            SDB.SelectCommand.ExecuteNonQuery();
            con.Close();
            sendCode();
            IDlabel.Show();
        }
 public Create_User()
 {
     InitializeComponent();
     IDlabel.Hide();
 }