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");
}
}
