Update SQl Server 2000

Hi!



I am trying to update my table Members in my SQL server database "Portfolio".



When I click the button, It throws an exception with the following message: "String or binary data would be truncated.
The statement has been terminated."



The code I wrote is as follows:



Private Sub UpdateUser()

If Page.IsValid Then

Dim cmd As New SqlCommand

Dim sqlQuery As String

Dim sb As New StringBuilder

Dim values As New ArrayList

sb.Append("UPDATE Members SET ")

sb.Append("Email='{0}', UserName='{1}', Pass_word='{2}'")

sb.Append("WHERE MemberID='{3}'")

values.Add(txtEmail.Text)

values.Add(txtUserName.Text)

values.Add(txtPassword.Text)

values.Add(Context.User.Identity.Name)

sqlQuery = String.Format(sb.ToString(), values.ToArray())

cmd = New SqlCommand(sqlQuery, SqlConnection1)

SqlConnection1.Open()

Try

cmd.ExecuteNonQuery()

lblMessage.Visible = True

lblMessage.Text = "You have updated your details successfully!"

Catch ex As Exception

lblMessage.Visible = True

lblMessage.ForeColor = Color.Red

lblMessage.Text = "Couldn't update your details!"

Trace.Warn(ex.Message)

Finally

SqlConnection1.Close()

End Try

End If

End Sub



I have already retrieved the data with a select statement in the Load event of the page.

I have tried to debug it but all the data seems to be loading in the right fields and the connection also opens normally.

If someone can explain to me I would be very grateful.