Dataset shows error: “Failed to convert parameters to Byte[]“
This error prompted when I tried to preview the data of the query I added for the dataset. The query is designed to accept a parameter which would check for the value on one of the field. Theoretically, the query should works as it is but the error “failed to convert parameter value from a string to byte[]” shows. Trying to input the parameter by running the query builder prompted below:
“Invalid value for cell (row 1, column 2).
The changed value in this cell was not recognized as valid.
.Net Framework Data Type: Byte[]
Error Message: You cannot use the Result pane to set this Field data to values other than NULL.
Type a value appropriate for the data type or press ESC to cancel the change.”
This has kept me puzzled for sometime and searching around the internet to no avail. I resorted to re-create the dataset and add back the query which surprisingly resolves the problem!
It sounds weird but that’s how it have drain down my time!
Keywords:
- dataset failed to convert parameter value
- vb net you cannot use the results pane to set this field data to values other than null
Written by admin on July 7th, 2010 with
no comments.
Read more articles on Knowledge Base and Programming.
- [+] Digg: Feature this article
- [+] Del.icio.us: Bookmark this article
- [+] Furl: Bookmark this article