Button Click event with if statement.

Marcus Dutton

Is there a way to run a method in a button click event. Say an update method, that if the method updates successfully it returns a value of true and if not then false?

Basically I have a class that houses my connection string, db insert, update, and delete methods, what I need to do is on my form that initiates the update method I need it to update a statusbar text field with a timer.

here is the code from my form with the button.

      private void btnUpdate_Click(object sender, EventArgs e)
        {
            Employee upEmp = new Employee();
            upEmp.FullName1 = tbxFullName.Text;
            upEmp.ShortName1 = tbxShortName.Text;
            upEmp.Title1 = cbxTitle.Text;
            upEmp.OfficePhone1 = cbxOfficePhone.Text;
            upEmp.HomePhone1 = mtbHomePhone.Text;
            upEmp.MobilePhone1 = mtbMobilePhone.Text;
            upEmp.DateOfBirth1 = Convert.ToDateTime(mtbxDoB.Text);
            upEmp.Active1 = cbxActive.Text;
            upEmp.Type1 = cbxType.Text;
            upEmp.EmergPhone1 = mtbContactPhone.Text;
            upEmp.EmergContact1 = tbxEmergContact.Text;
            int index = empMainListView.SelectedItems[0].Index;
            List empUpdate = dbconnect.Load();
            upEmp.ID1 = empUpdate[index].ID1;
            dbconnect.Update(upEmp);
        }

here is the code my my class file that houses my connection string and update method

public void Update(Employee upEmp)
        {
            try
            {
                dbcommand.CommandText = "UPDATE tblEmployee SET FullName=@vFullName, ShortName=@vShortName, Title=@vTitle, OfficePhone=@vOffice, HomePhone=@vHome, MobilePHone=@vMobile, DateOfBirth=@vDob, Type=@vType, Active=@vActive, EmergPhone=@vEPhone, EmergContact=@vEContact WHERE ID=@vID";
                dbcommand.Parameters.AddWithValue("@vFullName", upEmp.FullName1);
                dbcommand.Parameters.AddWithValue("@vShortName", upEmp.ShortName1);
                dbcommand.Parameters.AddWithValue("@vTitle", upEmp.Title1);
                dbcommand.Parameters.AddWithValue("@vOffice", upEmp.OfficePhone1);
                dbcommand.Parameters.AddWithValue("@vHome", upEmp.HomePhone1);
                dbcommand.Parameters.AddWithValue("@vMobile", upEmp.MobilePhone1);
                dbcommand.Parameters.AddWithValue("@vDob", upEmp.DateOfBirth1);
                dbcommand.Parameters.AddWithValue("@vType", upEmp.Type1);
                dbcommand.Parameters.AddWithValue("@vActive", upEmp.Active1);
                dbcommand.Parameters.AddWithValue("@vEPhone", upEmp.EmergPhone1);
                dbcommand.Parameters.AddWithValue("@vEContact", upEmp.EmergContact1);
                dbcommand.Parameters.AddWithValue("@vID", upEmp.ID1);
                dbcommand.CommandType = System.Data.CommandType.Text;
                dbconnect.Open();
                dbcommand.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                System.Windows.Forms.MessageBox.Show(ex.Message);
            }
            finally
            {
                dbconnect.Close();
            }
        }

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ranjit Powar10y ago
Accepted answer
Change Update method as below

public int Update(Employee upEmp)
{
into result=0;
try
{
dbcommand.CommandText = "UPDATE tblEmployee SET FullName=@vFullName, ShortName=@vShortName, Title=@vTitle, OfficePhone=@vOffice, HomePhone=@vHome, MobilePHone=@vMobile, DateOfBirth=@vDob, Type=@vType, Active=@vActive, EmergPhone=@vEPhone, EmergContact=@vEContact WHERE ID=@vID";
dbcommand.Parameters.AddWithValue("@vFullName", upEmp.FullName1);
dbcommand.Parameters.AddWithValue("@vShortName", upEmp.ShortName1);
dbcommand.Parameters.AddWithValue("@vTitle", upEmp.Title1);
dbcommand.Parameters.AddWithValue("@vOffice", upEmp.OfficePhone1);
dbcommand.Parameters.AddWithValue("@vHome", upEmp.HomePhone1);
dbcommand.Parameters.AddWithValue("@vMobile", upEmp.MobilePhone1);
dbcommand.Parameters.AddWithValue("@vDob", upEmp.DateOfBirth1);
dbcommand.Parameters.AddWithValue("@vType", upEmp.Type1);
dbcommand.Parameters.AddWithValue("@vActive", upEmp.Active1);
dbcommand.Parameters.AddWithValue("@vEPhone", upEmp.EmergPhone1);
dbcommand.Parameters.AddWithValue("@vEContact", upEmp.EmergContact1);
dbcommand.Parameters.AddWithValue("@vID", upEmp.ID1);
dbcommand.CommandType = System.Data.CommandType.Text;
dbconnect.Open();
result=dbcommand.ExecuteNonQuery();
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
}
finally
{
dbconnect.Close();
}
return result;
}

And button click event as

private void btnUpdate_Click(object sender, EventArgs e)
{
Employee upEmp = new Employee();
upEmp.FullName1 = tbxFullName.Text;
upEmp.ShortName1 = tbxShortName.Text;
upEmp.Title1 = cbxTitle.Text;
upEmp.OfficePhone1 = cbxOfficePhone.Text;
upEmp.HomePhone1 = mtbHomePhone.Text;
upEmp.MobilePhone1 = mtbMobilePhone.Text;
upEmp.DateOfBirth1 = Convert.ToDateTime(mtbxDoB.Text);
upEmp.Active1 = cbxActive.Text;
upEmp.Type1 = cbxType.Text;
upEmp.EmergPhone1 = mtbContactPhone.Text;
upEmp.EmergContact1 = tbxEmergContact.Text;
int index = empMainListView.SelectedItems[0].Index;
List empUpdate = dbconnect.Load();
upEmp.ID1 = empUpdate[index].ID1;
int result= dbconnect.Update(upEmp);
if(result>0)
MessageBox.Show ("Update successful.");
else
MessageBox.Show ("Not updated.");
}
Marcus Dutton10y ago
Thank you so much that worked perfectly after I made some further adjustments to other code. I have been pulling my hair out with that. And you also taught me a new trick of the trade.
Ranjit Powar10y ago
Oh sorry that's typing mistake Update method.

int result=0;
Ranjit Powar10y ago
Oh sorry that's typing mistake Update method.

int result=0;
Marcus Dutton10y ago
I'm getting an error that states "The Type or namespace name 'into' could not be found (are you missing a using directive or an assembly reference?)
Marcus Dutton10y ago
Could you give me an example?
Ranjit Powar10y ago
ExecuteNonQuery method returns number of affected you return that count from Upadate method and in button click event check if count is greater than 0