String Or Binary Data Would Be Truncated. The Statement Has Been Terminated.

I am working on Updating information from a table using Sql Server, but I keep receiving the error "String or binary data would be truncated. The statement has been terminated."


I have changed my maxlength of each textbox to equal the columns of my table but keep receiving the same answer. I also increased the lengths to make sure there was enough space, but no successful ending. Can anyone help? Here is my code and error message.





***************************************************************************


Sub btnSubmit_Click( s As Object, e As EventArgs )


Dim strUpdate As String


Dim cmdSelectData3 As SqlCommand


Dim conMyData As SqlConnection








conMyData = New SqlConnection("Server=helpdesk01; UID=sa;


PWD=****; database=ASPState" )








cmdSelectData3 = New SqlCommand("MemberUpdate", conMyData)


cmdSelectData3.CommandType = CommandType.StoredProcedure


cmdSelectData3.Parameters.Add("@MTitle", radMr.Text)


cmdSelectData3.Parameters.Add("@First", trim(txtFirstname.text))


cmdSelectData3.Parameters.Add("@Middle", trim(txtMiddlename.Text))


cmdSelectData3.Parameters.Add("@Last", trim(txtLastname.text))


cmdSelectData3.Parameters.Add("@Country", trim(dropCountry.SelectedItem.text))


cmdSelectData3.Parameters.Add("@Email", trim(txtEmail.text))


cmdSelectData3.Parameters.Add("@Promo", chkPromoUpdate.text)


cmdSelectData3.Parameters.Add("@Genre", trim(dropGenre.SelectedItem.text))





conMyData.Open()





cmdSelectData3.ExecuteNonQuery() (**error in Red**)





conMyData.Close()


End Sub








*************************************************************************