private void button2_Click(object sender, EventArgs e) { MainAppWindow maw = new MainAppWindow(); maw.Show(); this.Close(); }
private void button2_Click(object sender, EventArgs e) { if (textBox1.Text == "" || textBox2.Text == "") { MessageBox.Show("Enter correct details"); textBox1.Clear(); textBox2.Clear(); } else { try { using (SqlConnection conn = new SqlConnection("Data Source=HAIER-PC\\SQLEXPRESS;Initial Catalog=TodoListDatabase;Integrated Security=True")) { conn.Open(); string cmd = "SELECT STUDENT_ID FROM USERS WHERE STUDENT_ID = '" + Convert.ToInt32(textBox1.Text) + "' AND PASSWORD = '******'"; SqlDataAdapter da = new SqlDataAdapter(cmd, conn); DataSet ds = new DataSet(); da.Fill(ds); DataTable dt = ds.Tables[0]; conn.Close(); if (dt.Rows.Count >= 1) { settext = Convert.ToInt32(textBox1.Text); MainAppWindow maw = new MainAppWindow(); maw.Show(); this.Close(); } else { MessageBox.Show("Wrong username/pass combination"); textBox1.Clear(); textBox2.Clear(); } } } catch { MessageBox.Show("Invalid username/password"); } } }
private void add_Click(object sender, EventArgs e) { if (textBox1.Text != "") { using (SqlConnection conn = new SqlConnection("Data Source=HAIER-PC\\SQLEXPRESS;Initial Catalog=TodoListDatabase;Integrated Security=True")) { conn.Open(); SqlCommand add = conn.CreateCommand(); add.CommandType = CommandType.Text; add.CommandText = "INSERT INTO TASKS (Student_ID, Task_Name, Deadline) VALUES ('" + Form1.settext + "', '" + textBox1.Text + "', '" + dateTimePicker1.Value + "')"; add.ExecuteNonQuery(); conn.Close(); MessageBox.Show(string.Format("{0} has been added", textBox1.Text)); MainAppWindow maw = new MainAppWindow(); maw.Show(); this.Close(); } } else { MessageBox.Show("Enter correct values"); } }