private void btnUpdate_Click(object sender, EventArgs e) { Boolean iRowsAffected = false; iRowsAffected = dbAccessLayer.UpdateTable("tblempmaster", new String[] { "EmpName", "EmpType", "EmpDepartment", "EmpShip", "EmpStatus", "EmpFrom", "EmpTo", "Designation" }, new String[] { txtEmpName.Text, cmbBoxEmpType.SelectedValue.ToString(), cmbBoxEmpDept.SelectedValue.ToString(), cmbBoxShip.SelectedValue.ToString(), rdBtnActive.Checked ?"1":"0", txtFromDate.Text, txtToDate.Text, txtPassWord.Text }, new String[] { "EmpNo" }, new String[] { txtEmpNo.Text }); if (iRowsAffected) { MessageBox.Show("Details Updated Successfully"); } else { MessageBox.Show("Updation failed"); } }
private void btnUpdate_Click(object sender, EventArgs e) { Boolean iRowsAffected = false; iRowsAffected = dbAccessLayer.UpdateTable("tblshiptypemaster", new String[] { "ShipType", "ShipTypeDesc" }, new String[] { txtShipTypeName.Text, txtShipTypeDesc.Text }, new String[] { "ShiptypeID" }, new String[] { txtShipTypeID.Text }); if (iRowsAffected) { MessageBox.Show("Details Updated Successfully"); } else { MessageBox.Show("Updation failed"); } }
private void btnUpdate_Click(object sender, EventArgs e) { Boolean iRowsAffected = false; iRowsAffected = dbAccessLayer.UpdateTable("tblshipmaster", new String[] { "ShipName", "Fleet", "ShipType", "ShipSize", "ShipCapacity" }, new String[] { txtShipName.Text, cmbBoxFleet.SelectedValue.ToString(), cmbBoxShipType.SelectedValue.ToString(), txtShipSize.Text, txtShipCapacity.Text }, new String[] { "ShipNo" }, new String[] { txtShipNo.Text }); if (iRowsAffected) { MessageBox.Show("Details Updated Successfully"); } else { MessageBox.Show("Updation failed"); } }