private void savebtn_Click(object sender, EventArgs e) { string sex; DialogResult result = MessageBox.Show("Are You Sure You Want To Save?", "Save", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { DBConnect conn = new DBConnect(); conn.OpenConnection(); if (femaleradiobtn.Checked) { sex = "F"; } else { sex = "M"; } string query1 = "INSERT INTO student(StuNo,FullName,LName,Initials,Address,ContactNo,Sex,Batch,Degree,SpSubject,NID,DeptNo,UserName,IntakeYear) VALUES('" + stunotxt.Text + "','" + fullnametxt.Text + "','" + lnametxt.Text + "','" + initialstxt.Text + "','" + addresstxt.Text + "','" + mobiletxt.Text + "','" + sex + "','" + Batchtxt.Text + "','S','Kandyan Dance','" + NIDtxt.Text + "','DKAN 01','" + stunotxt.Text + "','" + intyeartxt.Text + "')"; if (conn.OpenConnection() == true) { MySqlCommand cmd = new MySqlCommand(query1, conn.connection); cmd.ExecuteNonQuery(); conn.CloseConnection(); } this.Close(); Form3 f3 = new Form3(); f3.Show(); } }
private void stunotxt_TextChanged(object sender, EventArgs e) { DBConnect conn = new DBConnect(); conn.OpenConnection(); string query1 = "SELECT * FROM student where StuNo='" + stunotxt.Text + "'"; if (conn.OpenConnection() == true) { MySqlCommand cmd = new MySqlCommand(query1, conn.connection); MySqlDataReader datareader = cmd.ExecuteReader(); while (datareader.Read()) { fullnametxt.Text = datareader.GetString(1); lnametxt.Text = datareader.GetString(2); initialstxt.Text = datareader.GetString(3); addresstxt.Text = datareader.GetString(4); mobiletxt.Text = datareader.GetString(5); NIDtxt.Text = datareader.GetString(10); intyeartxt.Text = datareader.GetString(13); Batchtxt.Text = datareader.GetString(7); string sex = datareader.GetString(6); if (sex == "M") { maleradiobtn.Checked = true; } else { femaleradiobtn.Checked = true; } } datareader.Close(); conn.CloseConnection(); } }
private void btnDelete_Click(object sender, EventArgs e) { DBConnect conn = new DBConnect(); string deleteQuery = "delete from account where UserName='******'"; DialogResult result = MessageBox.Show("Are you sure to delete record?", "delete", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (result == DialogResult.OK) { if (conn.OpenConnection() == true) { MySqlCommand cmd = new MySqlCommand(deleteQuery, conn.connection); if (cmd.ExecuteNonQuery() == 1) { MessageBox.Show("Deleted"); } else { MessageBox.Show("Not Deleted"); } conn.CloseConnection(); } else { } } else { MessageBox.Show("Not deleted"); } populateDGV(); }
private void cdeletebtn_Click(object sender, EventArgs e) { DBConnect conn = new DBConnect(); string deleteQuery = "delete from subject where SubjectId='" + cidtxt.Text + "'"; DialogResult result = MessageBox.Show("Are you sure to delete record?", "delete", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (result == DialogResult.OK) { if (conn.OpenConnection() == true) { MySqlCommand cmd = new MySqlCommand(deleteQuery, conn.connection); if (cmd.ExecuteNonQuery() == 1) { MessageBox.Show("Course is Deleted"); } else { MessageBox.Show("Course is not Deleted"); } conn.CloseConnection(); } else { } } else { MessageBox.Show("Course is not deleted"); } clearbtn.PerformClick(); }
private void caddbtn_Click(object sender, EventArgs e) { DBConnect conn = new DBConnect(); conn.OpenConnection(); this.addconversions(); string query1 = "INSERT INTO subject(SubjectId,SubCode,SubName,SubType,Subcredit,Sem,YearId,AcYear,DeptNo) VALUES('" + cid + "','" + ccodetxt.Text + "','" + ctitletxt.Text + "','" + ctype + "','" + ccreditstxt.Text + "','" + csem + "','" + cyear + "','" + cacayeartxt.Text + "','" + cdept + "')"; if (conn.OpenConnection() == true) { MySqlCommand cmd = new MySqlCommand(query1, conn.connection); cmd.ExecuteNonQuery(); conn.CloseConnection(); } MessageBox.Show("Course is Added"); clearbtn.PerformClick(); }
private void btnAdd_Click(object sender, EventArgs e) { DBConnect conn = new DBConnect(); conn.OpenConnection(); string query1 = "INSERT INTO account(UserName,Password,PasswordHint) VALUES ('" + txtUsername.Text + "','" + txtPasswotd.Text + "','" + txtPasswotd.Text + "')"; if (conn.OpenConnection() == true) { MySqlCommand cmd = new MySqlCommand(query1, conn.connection); if (cmd.ExecuteNonQuery() == 1) { MessageBox.Show("Save data"); } else { MessageBox.Show("Query Not Executed"); } conn.CloseConnection(); } populateDGV(); }
private void areports_Load(object sender, EventArgs e) { DBConnect conn = new DBConnect(); string Query = "SELECT * FROM student"; conn.OpenConnection(); MySqlCommand command = new MySqlCommand(Query, conn.connection); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { stureportcombo.Items.Add(reader.GetString("StuNo")); } conn.CloseConnection(); }
public void populateDGV() { //populate the datagridview DBConnect conn = new DBConnect(); conn.OpenConnection(); string selectQuery = "SELECT*FROM account"; //ListSortDirection direction; //dataGridView_accou.Sort(dataGridView_accou.Columns["password"], direction); // dataGridView_accou.Sort(dataGridView_accou.Columns[1], ListSortDirection.Ascending); DataTable table = new DataTable(); MySqlDataAdapter adapter = new MySqlDataAdapter(selectQuery, conn.connection); adapter.Fill(table); // dataGridView_accou.Sort(dataGridView_accou.Columns[1], ListSortDirection.Ascending); dataGridView_accou.DataSource = table; conn.CloseConnection(); }
private void savebtn_Click(object sender, EventArgs e) { if (pword == currentpwordtxt.Text && (newpwordtxt.Text == confirmpwordtxt.Text)) { DBConnect conn = new DBConnect(); conn.OpenConnection(); string query1 = "update account set Password = '******' where UserName = '******' "; MySqlCommand cmd = new MySqlCommand(query1, conn.connection); MySqlDataReader rdr = cmd.ExecuteReader(); conn.CloseConnection(); } else if (pword != currentpwordtxt.Text) { MessageBox.Show("curreent password is wrong"); } else { MessageBox.Show("new password is wrong"); } }
private void btnShow_Click(object sender, EventArgs e) { DBConnect conn = new DBConnect(); string updateQuery = "UPDATE account SET UserName='******',Password='******',PasswordHint='" + this.txtPasswotd.Text + "' WHERE UserName='******';"; if (conn.OpenConnection() == true) { MySqlCommand cmd = new MySqlCommand(updateQuery, conn.connection); if (cmd.ExecuteNonQuery() == 1) { MessageBox.Show("Data Updated Successfully"); } else { MessageBox.Show("Query Not Executed"); } conn.CloseConnection(); } populateDGV(); }
private void ceditbtn_Click(object sender, EventArgs e) { DBConnect conn = new DBConnect(); this.addconversions(); string updateQuery = "UPDATE subject SET SubjectId='" + this.cid + "',SubCode='" + this.ccodetxt.Text + "',SubName='" + this.ctitletxt.Text + "',SubType='" + this.ctype + "',SubCredit='" + this.ccredit + "',Sem='" + this.csem + "',YearId='" + this.cyear + "',AcYear='" + this.cacayeartxt.Text + "',DeptNo='" + this.cdept + "' WHERE SubjectId='" + this.cid + "';"; if (conn.OpenConnection() == true) { MySqlCommand cmd = new MySqlCommand(updateQuery, conn.connection); if (cmd.ExecuteNonQuery() == 1) { MessageBox.Show("Data Updated Successfully"); } else { MessageBox.Show("Query Not Executed"); } conn.CloseConnection(); } clearbtn.PerformClick(); }
public Form1() { InitializeComponent(); conn.OpenConnection(); }
private void cidtxt_TextChanged(object sender, EventArgs e) { DBConnect conn = new DBConnect(); conn.OpenConnection(); string query1 = "SELECT * FROM subject where SubjectId='" + cidtxt.Text + "'"; if (conn.OpenConnection() == true) { MySqlCommand cmd = new MySqlCommand(query1, conn.connection); MySqlDataReader datareader = cmd.ExecuteReader(); while (datareader.Read()) { ccodetxt.Text = datareader.GetString(1); ctitletxt.Text = datareader.GetString(2); if (datareader.GetString(3) == "C") { ctypetxt.Text = "Core"; } else if (datareader.GetString(3) == "E") { ctypetxt.Text = "Elective"; } else { ctypetxt.Text = "Auxilary"; } ccreditstxt.Text = Convert.ToString(datareader.GetInt32(4)); if (datareader.GetString(5) == "1") { csemtxt.Text = "Semester 1"; } else { csemtxt.Text = "Semester 2"; } if (datareader.GetString(6) == "1") { cyeartxt.Text = "One"; } else if (datareader.GetString(6) == "2") { cyeartxt.Text = "Two"; } else if (datareader.GetString(6) == "3") { cyeartxt.Text = "Three"; } else { cyeartxt.Text = "Four"; } cacayeartxt.Text = datareader.GetString(7); if (datareader.GetString(8) == "DKAN 01") { cdepttxt.Text = "Kandyan Dance"; } else if (datareader.GetString(8) == "DKAN 02") { cdepttxt.Text = "Low-Country Dance"; } else if (datareader.GetString(8) == "DKAN 03") { cdepttxt.Text = "Sabaragamuwa Dance"; } else if (datareader.GetString(8) == "DKAN 04") { cdepttxt.Text = "Indian and Asian Dance"; } else if (datareader.GetString(8) == "DKAN 05") { cdepttxt.Text = "Percussion Music"; } else if (datareader.GetString(8) == "DKAN 06") { cdepttxt.Text = "History and Theory of Dance and Drama"; } else { cdepttxt.Text = "Theatre, Ballet and Modern Dance"; } } datareader.Close(); conn.CloseConnection(); } }