Loading

Conversion Error:Input string was not in correct format

karthik parcha

HI
This is my code
paramCol[2] = new SqlParameter("@SalesWeek", SqlDbType.TinyInt);
paramCol[2].Value =Convert.ToByte(lblSalesWeek.Text.Trim());

In my Storedprocedure Sakesweek datatype is Tiny int
so when i convert getting error like input string was not in correct format
plz help me how to convert this code

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Trivedi14y ago
hi,

I agree with above post.
but kindly check your input it may be character or other than number.
hope this help.
Vulpes14y ago
The error message is indicating that lblSalesWeek.Text doesn't contain something that can be parsed to a byte - perhaps it's an empty string or contains some characters which are not digits.

You can substitute a byte value of 0 in the event of the input being invalid like so:

byte b;
Byte.TryParse(lblSalesWeek.Text.Trim(), out b);
paramCol[2].Value = b;