Object Must Implement IConvertible

[mikester20]

This is supposed to fire when a button is clicked, however when the button is clicked I get the following error.

Object must implement IConvertible.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidCastException: Object must implement IConvertible.

Source Error:


Line 124:
Line 125: sqlconn.Open();
Line 126: sqlcmd.ExecuteNonQuery();
Line 127: sqlconn.Close();
Line 128:


This is the code that runs when the button is clicked.



SqlConnection sqlconn = new SqlConnection("Data Source=vnadbms01;initial catalog=LDMS; " + "integrated security=true;persist security info=True;");
SqlCommand sqlcmd = new SqlCommand("NWH_Intranet_Update_Employees", sqlconn);


// SqlCommand cmd = new SqlCommand("NWH_Intranet_Update_Employees", PhoneDirConn);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.Add("@AM_EMPID", SqlDbType.Int).Value = txtEmpID.Text;
sqlcmd.Parameters.Add("@AM_ADUSER", SqlDbType.VarChar).Value = txtAccnt.Text;
sqlcmd.Parameters.Add("@AM_BRANCH", SqlDbType.VarChar).Value = txtOffice.Text;
sqlcmd.Parameters.Add("@AM_DEPARTMENT", SqlDbType.VarChar).Value = txtDepartment.Text;
sqlcmd.Parameters.Add("@AM_EMAIL", SqlDbType.VarChar).Value = txtEmailAdd;
sqlcmd.Parameters.Add("@AM_EMPNOTES", SqlDbType.VarChar).Value = txtEmpNotes.Text;
sqlcmd.Parameters.Add("@AM_EMPSTATUS", SqlDbType.VarChar).Value = lstStatus.SelectedItem.Value;
sqlcmd.Parameters.Add("@AM_FIRSTNAME", SqlDbType.VarChar).Value = txtFirstName.Text;
sqlcmd.Parameters.Add("@AM_JOBRESPONSIBLITY", SqlDbType.VarChar).Value = txtJobResp.Text;
sqlcmd.Parameters.Add("@AM_LASTNAME", SqlDbType.VarChar).Value = txtLastName.Text;
sqlcmd.Parameters.Add("@AM_MIDDLENAME", SqlDbType.VarChar).Value = txtMidName.Text;
sqlcmd.Parameters.Add("@AM_PHONEEXT", SqlDbType.Int).Value = txtPhoneExt.Text;
sqlcmd.Parameters.Add("@AM_POSITION", SqlDbType.VarChar).Value = txtPosition.Text;
sqlcmd.Parameters.Add("@AM_MODIFY_RIGHTS", SqlDbType.VarChar).Value = lstModify.SelectedItem.Value;

sqlconn.Open();
sqlcmd.ExecuteNonQuery();
sqlconn.Close();

[Phil Weber]

My guess is that it's one of the lines trying to assign a string value to an int parameter:

sqlcmd.Parameters.Add("@AM_EMPID", SqlDbType.Int).Value = txtEmpID.Text;
sqlcmd.Parameters.Add("@AM_PHONEEXT", SqlDbType.Int).Value = txtPhoneExt.Text;

You might try changing those lines to something like:

...Value = CInt(txtEmpID.Text)

Also, make sure the textboxes do indeed contain numeric values.

[sftwin]

I had the same error message. I checked for the INT columns in my database and found out that I was trying to push a String value into a Int column in my database.

Thanks!