コード例 #1
0
        private void Login_Click(object sender, RoutedEventArgs e)
        {
            if (textbox1.Text.Length == 0)
            {
                MessageBox.Show("Enter Email", "Confirmation", MessageBoxButton.OK, MessageBoxImage.Warning);
                textbox1.Focus();
            }
            else if (textbox2.Password.Length == 0)
            {
                MessageBox.Show("Enter Password", "Confirmation", MessageBoxButton.OK, MessageBoxImage.Warning);
                textbox2.Focus();
            }
            else
            {
                string        email    = textbox1.Text;
                string        password = textbox2.Password;
                SqlConnection con      = new SqlConnection(@"Data Source=DESKTOP-NN9ENGI\SQLEXPRESS;Initial Catalog=SOURCE;Integrated Security=True");
                con.Open();
                SqlCommand cmd = new SqlCommand("Select * from Register where Email='" + email + "'  and password='******'", con);
                cmd.CommandType = CommandType.Text;
                SqlDataAdapter adapter = new SqlDataAdapter();
                adapter.SelectCommand = cmd;
                DataSet dataSet = new DataSet();
                adapter.Fill(dataSet);
                if (dataSet.Tables[0].Rows.Count > 0)
                {
                    textbox1_name.Text = dataSet.Tables[0].Rows[0]["Name"].ToString();

                    string a = textbox1_name.Text;
                    textbox1_Email.Text = dataSet.Tables[0].Rows[0]["Email"].ToString();
                    string b = textbox1_Email.Text;
                    textbox1_Password.Password = dataSet.Tables[0].Rows[0]["Password"].ToString();
                    string    c  = textbox1_Password.Password;
                    QueryForm qf = new QueryForm(a, b, c);
                    qf.Owner = this;
                    this.Hide();
                    qf.ShowDialog();
                    //string username = dataSet.Tables[0].Rows[0]["FirstName"].ToString() + " " + dataSet.Tables[0].Rows[0]["LastName"].ToString();
                    // welcome.TextBlockName.Text = username;//Sending value from one form to another form.
                    // welcome.Show();
                    // Close();
                }
                else
                {
                    MessageBox.Show("Sorry! Please enter existing emailid/password.", "Alert", MessageBoxButton.OK, MessageBoxImage.Warning);

                    //  errormessage.Text = "";
                }
                con.Close();
            }
        }
コード例 #2
0
        private void Button_Click(object sender, RoutedEventArgs e)
        {
            if (textbox1.Text == "Admin" && textbox2.Password == "Admin")
            {
                if (Combobox1.Text == "System Progress")
                {
                    ADMINFLATE AF = new ADMINFLATE();
                    AF.Owner = this;
                    this.Hide();
                    AF.ShowDialog();
                }
                if (Combobox1.Text == "Query")
                {
                    string a = "Admin";
                    string b = "Admin";
                    string c = "Admin";

                    QueryForm qf = new QueryForm(a, b, c);
                    qf.Owner = this;
                    this.Hide();
                    qf.ShowDialog();
                    //   Close();
                    /// normal form of query
                }
            }

            else if (textbox1.Text != "admin" && textbox2.Password != "admin")
            {
                if (textbox1.Text != "admin")
                {
                    MessageBox.Show("Invalid Email");
                }

                else
                {
                    MessageBox.Show("Invalid Password");
                }
            }
            else
            {
                MessageBox.Show("Invalid Email & Password");
            }
        }