private void LogInNow() { //String str = "Data Source=localhost\\sqlexpress;Initial Catalog=master; Integrated Security=True"; //String str = "Data Source=d:\\1.sdf; Persist Security Info=False"; //SqlCeConnection con = new SqlCeConnection(str); SqlCeConnection con = new SqlCeConnection("Data Source=" + Application.StartupPath + "\\1.sdf; Persist Security Info=False"); //SqlCommand cmd = new SqlCommand("select * from UserProfile where LogInUser=@LogInUser and LogInPass =@LogInPass", con); SqlCeCommand cmd = new SqlCeCommand("select * from UserProfile where LogInUser=@LogInUser and LogInPass =@LogInPass", con); cmd.Parameters.AddWithValue("@LogInUser", textBox1.Text); cmd.Parameters.AddWithValue("@LogInPass", textBox2.Text); SqlCeDataAdapter sda = new SqlCeDataAdapter(cmd); DataTable dt = new DataTable(); sda.Fill(dt); //Connection open here con.Open(); int i = cmd.ExecuteNonQuery(); con.Close(); if (dt.Rows.Count > 0 & portalSelect.Text != "") { switch (portalSelect.Text) { case "MainWindowOpener": this.Hide(); Main f2 = new Main(); f2.Show(); break; case "EntryReportOpener": this.Hide(); EntryReport f3 = new EntryReport(); f3.Show(); break; } } else if (dt.Rows.Count > 0 & portalSelect.Text == "") { MessageBox.Show("لطفا زیر پورتال مورد نظر را انتخاب کنید."); } else { //MessageBox.Show("نام کاربری یا رمز عبور صحیح نمی باشد."); MsgBox frm = new MsgBox("نام کاربری یا رمز عبور صحیح نمی باشد.", "قبول"); frm.ShowDialog(); } }
private void button3_Click(object sender, EventArgs e) { EntryReport report = new EntryReport(); report.ShowDialog(); }