private void btnsave_Click(object sender, EventArgs e) { String Sql = "Insert into Table_Accused(Accused_fullname, Section_of_Law, Complain_Status, Complain_Details, Victim_Name, Accused_Name) " + "values('" + txtfullname.Text + "', '" + txtfathername.Text + "', '" + txtaddress.Text + "', '" + txtnic.Text + "', '" + txtgender.Text + "', '" + txtstatus.Text + "', '" + txtcontact.Text + "', '" + txtemail.Text + "')".ToString(); accusedgridview.DataSource = DBConnection.GetTableByQuery(Sql); dataload(); }
private void btndelete_Click(object sender, EventArgs e) { string query = "Delete from Table_InvestigationOfficer where Officer_ID = '" + txtofficerid.Text + "'"; Officergridview.DataSource = DBConnection.GetTableByQuery(query); MessageBox.Show("Officer Record Deleted Successfully"); dataLoad(); }
private void btnsave_Click(object sender, EventArgs e) { String Sql = "Insert into Table_Complain(Complain_Date, Section_of_Law, Complain_Status, Complain_Details, Victim_Name, Accused_Name) " + "values('" + txtcomplaindate.Text + "', '" + txtsectionoflaw.Text + "', '" + txtcomplainstatus.Text + "', '" + txtcomplaindetails.Text + "', '" + txtvictimname.Text + "', '" + txtaccusedname.Text + "')".ToString(); complaingridview.DataSource = DBConnection.GetTableByQuery(Sql); dataload(); }
private void btndelete_Click(object sender, EventArgs e) { string query = "Delete from Table_Complain where Complain_ID = '" + txtcomplainid.Text + "'"; complaingridview.DataSource = DBConnection.GetTableByQuery(query); MessageBox.Show("Complaint Deleted Successfully"); dataload(); }
private void btnsave_Click(object sender, EventArgs e) { String Sql = "Insert into Table_InvestigationOfficer(Full_Name, Rank) " + "values('" + txtfullname.Text + "', '" + txtrank.Text + "')".ToString(); Officergridview.DataSource = DBConnection.GetTableByQuery(Sql); dataLoad(); }
private void btndelete_Click(object sender, EventArgs e) { string query = "Delete from Table_Accused where Accused_ID = '" + txtaccusedid.Text + "'"; accusedgridview.DataSource = DBConnection.GetTableByQuery(query); MessageBox.Show("Accused Deleted Successfully"); dataload(); }
private void btnupdate_Click(object sender, EventArgs e) { String query = "update Table_Accused set fullname='" + txtfullname.Text + "',Section_of_Law='" + txtfathername.Text + "',Complain_Status='" + txtaddress.Text + "',Complain_Details='" + txtnic.Text + "',Victim_Name='" + txtgender.Text + "',Accused_Name='" + txtstatus.Text + "' where Accused_ID='" + txtaccusedid.Text + "' "; accusedgridview.DataSource = DBConnection.GetTableByQuery(query); MessageBox.Show("Data Updated Successfully"); dataload(); btnsave.Enabled = true; }
private void btnupdate_Click(object sender, EventArgs e) { String query = "update Table_Complain set Complain_Date='" + txtcomplaindate.Text + "',Section_of_Law='" + txtsectionoflaw.Text + "',Complain_Status='" + txtcomplainstatus.Text + "',Complain_Details='" + txtcomplaindetails.Text + "',Victim_Name='" + txtvictimname.Text + "',Accused_Name='" + txtaccusedname.Text + "' where Complain_ID='" + txtcomplainid.Text + "' "; complaingridview.DataSource = DBConnection.GetTableByQuery(query); MessageBox.Show("Data Updated Successfully"); dataload(); btnsave.Enabled = true; }
private void btnupdate_Click(object sender, EventArgs e) { String query = "update Table_InvestigationOfficer set Full_Name='" + txtfullname.Text + "',Rank='" + txtrank.Text + "' where Officer_ID='" + txtofficerid.Text + "' "; Officergridview.DataSource = DBConnection.GetTableByQuery(query); MessageBox.Show("Data Updated Successfully"); dataLoad(); btnsave.Enabled = true; }
public void OfficerDataLoad() { String Sql = "Select * from Table_InvestigationOfficer"; OfficerGridView.DataSource = DBConnection.GetTableByQuery(Sql); }
public void PetDataLoad() { String Sql = "Select * from Table_Petitioner"; petgridview.DataSource = DBConnection.GetTableByQuery(Sql); }
public void dataload() { String Sql = "Select * from Table_Complain"; complaingridview.DataSource = DBConnection.GetTableByQuery(Sql); }
public void ComplainDataLoad() { String Sql = "Select * from Table_Complain"; ComplainGridView.DataSource = DBConnection.GetTableByQuery(Sql); }
public void VictimDataLoad() { String Sql = "Select * from Table_Victim"; VictimGridView.DataSource = DBConnection.GetTableByQuery(Sql); }
public void dataload() { String Sql = "Select * from Table_Accused"; accusedgridview.DataSource = DBConnection.GetTableByQuery(Sql); }
public void dataLoad() { String sql = "Select * from Table_InvestigationOfficer"; Officergridview.DataSource = DBConnection.GetTableByQuery(sql); }
public void FIRDataLoad() { String Sql = "Select * from Table_FIR"; FIRGridView.DataSource = DBConnection.GetTableByQuery(Sql); }