ADO update error

[Tom Yaz]

I am getting a strange error when trying to update a field in my data table. Was happeining intermittingly, but now for every record:


Line 211: DataSetAttendance1.Attendance.Rows(0)("Description") = Trim(txt_description.Text)
Line 212: SqlDataAdapter2.Update(DataSetAttendance1)

Error:

Input string was not in a correct format.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.FormatException: Input string was not in a correct format.


Any clues?

Thanks

[salvelinus]

Is the data type in the dataset a/o db a string value?

[Memnoch1207]

try

DataSetAttendance1.Attendance.Rows(0)("Description") = Trim(txt_description.Text).ToString()

[Tom Yaz]

Tried that, no dice. Maybe a CType command?

This is so strange because it was working just fine, and has been no changes to that field in the table.

[Tom Yaz]

Okay the problem is a field that was changed from numeric to string. I deleted the dataset and created a new dataset from the adapter. The schema of the new dataset is good, but when I try to preview the data in the adapter I get an error saying the field is in bad format (still numeric) Do I have to create a new adaptor?

[Tom Yaz]

Okay the problem is a field that was changed from numeric to string. I deleted the dataset and created a new dataset from the adapter. The schema of the new dataset is good, but when I try to preview the data in the adapter I get an error saying the field is in bad format (still numeric) Do I have to create a new adaptor?

[Memnoch1207]

how are you creating the DataSet and DataAdapter? Are you just dragging and dropping them onto the form??? or are you creating them in code?

Yes, if the first one.
No, if the second.

[taxes]

Neither does being uneducated!!!

Taxes.