System.Data.OleDb.OleDbException

[Guest]

Hi

I having a strange error which has started coming up recently.

I have a textbox where one can enter the URL for a link. The textbox is not able to accept long Urls. the error which I get is
Exception Details: System.Data.OleDb.OleDbException: The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data

Source Error:

Line 1299: objCmd.Parameters("@URL").Value = CType(e.Item.Cells(2).Controls(1), TextBox).Tex
Line 1300
Line 1301: objCmd.ExecuteNonQuery(
Line 1302
Line 1303: ' tidy u

Would appreciate if someone can throw some light on the above error and possible solution

 

[Guest]

Please try to check whether you are typing data charecter longer then allowed in the DB field??? check for the type and length of "@URL" parameter also

Hope this help

Avneesh
MCAD, MCSD.Net

 

[Guest]

Thanks for the help Avneesh

Appreciate it.