String or binary data would be truncated. The statement has been terminated

[Robin25]

I'll trying to update some information, the data that i want to update its also came from same sql database, and that error showing . thanks in advance

[Rabbit]

Please post your code using code tags. As a general rule, I do not download attachments.

[Robin25]

 conn = GetConnect()
 
 
 
 
 
 
            MySqlCommand = New SqlCommand("Update Tbl_Member_Profile set F_Name='" & txt_F_Name.Text & 
 
"', M_Name='" & txt_M_Name.Text & "', L_Name='" & txt_L_Name.Text & "', Credit_Line='" & txt_cre_line.Text 
 
& "', Rec_Last_Update='" & Date.Today & "', Age='" & txt_age.Text & "', Date_Of_Birth='" & datepicker.Value 
 
& "', Credit_Rating='" & txt_ranking.Text & "', Membership_Category='" & txt_membership.Text & "' WHERE 
 
P_Member_Code='" & txt_Cus_No.Text & "'", conn)
 
 
            conn.Open()
 
 
 
 
 
            MySqlCommand.ExecuteNonQuery()
 
 

''like this one sir? im sorry this is my first time to join this kind of forum

[Rabbit]

That error means that one of the values you are inserting is too long for the field.

[mcupito]

You really haven't given us much to go on. You should really add Parameters when dealing with a database.

See my code for an example:

        Dim conn As New SqlConnection("Data Source=SQLTEST_HR,4000\SQLEXPRESS;Integrated Security=True")
        Dim cmd As New SqlCommand
 
        'insert statement
        cmd.CommandText &= " INSERT INTO ELECT_SALARY_DFRL (ELECT_XREF_SEQ_ID, EMPL_SALARY_DFRL_AMT, EMPL_SALARY_DFRL_FREQ_CD, "
        cmd.CommandText &= "  FUND_SEQ_ID, ELECT_SALARY_DFRL_FUND_PCT_RT, ELECT_SALARY_DFRL_ELECT_DT, BEG_DT, END_DT)"
        cmd.CommandText &= " VALUES (@SeqID, @DefAmt, @Freq, @FundID, @FundPct, @Today, @BegDT, @EndDT); "
 
        ' parameters for sql insert, from DGV
        cmd.Parameters.AddWithValue("@SeqID", empseqId)
        cmd.Parameters.Add("@DefAmt", SqlDbType.VarChar)
        cmd.Parameters.Add("@Freq", SqlDbType.VarChar)
        cmd.Parameters.Add("@FundID", SqlDbType.Int)
        cmd.Parameters.Add("@FundPct", SqlDbType.VarChar)
        cmd.Parameters.AddWithValue("@Today", Date.Now())
        cmd.Parameters.AddWithValue("@BegDT", "19000101")
        cmd.Parameters.AddWithValue("@EndDT", "24000101")
 
        conn.Open()
        cmd.Connection = conn
        cmd.ExecuteNonQuery()
 

I put the cmd.ExecuteNonQuery() in a Try Catch block to throw a meaningful exception, however that might be out of the scope for your sole inquiry.

Hope this helps.

[Robin25]

Thank you so much Mr.mcupito, it's really works. .
also Mr.Rabbit . .

[mcupito]

No problem. Hope it helps