Failed to convert parameter value from string to decimal
وقتی برنامه رو اجرا می کنم با این پیغام مواجه می شم
Failed to convert parameter value from a String to a Decimal.
اینم کد:
int intPosition, intMaxID;
String strID;
SqlCommand objCommand = newSqlCommand();
intPosition = objCurrencyManager.Position;
SqlCommand maxIdCommand = newSqlCommand("SELECT MAX(au_id) FROM authors WHERE au_id LIKE '999-88-'", objConnection);
objConnection.Open();
Object maxId = maxIdCommand.ExecuteScalar();
if (maxId == DBNull.Value)
{
intMaxID = 1000;
}
else
{
strID = (String)maxId;
intMaxID = int.Parse(strID.Remove(0, 7));
intMaxID += 1;
}
strID = "999-88-" + intMaxID.ToString();
objCommand.Connection = objConnection;
objCommand.CommandText =
"INSERT INTO authors (au_id, au_lname, au_fname, phone, address) " +
"VALUES(@au_id,@au_lname,@au_fname,@phone,@address )";
objCommand.Parameters.AddWithValue("@au_id", strID);
objCommand.Parameters.AddWithValue("au_lname", txtLastName.Text);
objCommand.Parameters.AddWithValue("au_fname", txtFirstName.Text);
objCommand.Parameters.AddWithValue("@phone", txtPhone.Text).DbType = DbType.Currency;
objCommand.Parameters.AddWithValue("@address", txtAddress.Text);
try
{
objCommand.ExecuteNonQuery();
}
catch (SqlException SqlExceptionErr)
{
MessageBox.Show(SqlExceptionErr.Message);
}
objConnection.Close();
پاسخ با نقل قول
