Example #1
0
        private void button1_Click(object sender, EventArgs e)
        {
            if (textBox1.Text == string.Empty)
            {
                errorProvider1.SetError(textBox1, "Required");
            }
            else if (textBox2.Text == string.Empty)
            {
                errorProvider1.SetError(textBox2, "Required");
            }

            else
            {
                cn.Open();
                SqlCommand    cmd = new SqlCommand("select [username],password from [registration] where [username]='" + textBox1.Text + "' and password='******'", cn);
                SqlDataReader dr  = cmd.ExecuteReader();
                if (dr.Read())
                {
                    if (textBox1.Text == dr[0].ToString() || textBox2.Text == dr[1].ToString())
                    {
                        FileSplitter.Master e1 = new    FileSplitter.Master(textBox1.Text);
                        e1.Show();
                        this.Hide();
                    }
                }
                else
                {
                    MessageBox.Show("Invalid username or password");
                }
                cn.Close();
            }
        }
Example #2
0
        private void button2_Click(object sender, EventArgs e)
        {
            cn.Open();
            SqlCommand    cmd = new SqlCommand("select name,otp from otp where [name]='" + textBox1.Text + "' and otp='" + textBox3.Text + "'", cn);
            SqlDataReader dr  = cmd.ExecuteReader();

            if (dr.Read())
            {
                if (textBox1.Text == dr[0].ToString() || textBox3.Text == dr[1].ToString())
                {
                    FileSplitter.Master e1 = new FileSplitter.Master(textBox1.Text);
                    e1.Show();
                    this.Hide();

                    s.insert("delete from otp where name='" + textBox1.Text + "'");
                }
            }
            else
            {
                MessageBox.Show("Invalid username or password");
            }
            cn.Close();
        }