I'm reading selected records from one table in a database into a dataset and
then trying to insert the records into a different table in the database using:
For Each dRow2 in ds.Tables(0).Rows
ret = MyInsertMethod(Trim(dRow2.Item(1)), Trim(dRow2.Item(2)),
Trim(dRow2.Item(3)), CDate(dRow2.Item(4)), CDate(dRow2.Item(5)), dRow2.Item(6),
Trim((dRow2.Item(7))))
response.write(ret & "Record added")
Next
I'm getting: System.Data.SqlClient.SqlException: String or binary data would be
truncated. The statement has been terminated.
Here is the Function:
Function MyInsertMethod(ByVal networkEng As String, ByVal task As String, ByVal
actionType As String, ByVal startDate As Date, ByVal endDate As Date, ByVal hrs
As Single, ByVal probComment As String) As Integer
Any ideas?
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
