input string was not in acorrect format

Question

Hi Everyone, I was wondering if someone could help me. I am trying to get the value of a parameter from a stored procedure. I keep getting the error "Input string was not in a correct format.". It looks like it is in the correct format to me. Any suggestions? Here's the code that gets the error..... customer.id=convert.toint32(rd[0].tostring) where rd is a sql dataReader read from the stored procedure

Answer 1

I know in c# you can do something like this

// If there is selected items do this
if (lisbox.items.selected != null)
{
// Code for your program here if the listbox is selected
}
// If there are no items selected then display this
else
{
 // Error display code here
}

You could maybe set up an error checker that way?

Answer 2

thank you for replaying my letter but: 1-customer.id is an interger value declare in my customer class 2-rd[0] only have single value from the stored procedure (select min(id) from customer ) the problem is when there is no data in the table it return Null i try to put all my code in TRY{} and CATCH{} but i doesnt work ,if you have ny idea to this setuation i need it very much in my project thanks again

Answer 3

I might be of some help....i'm still learning this feel free to correct me :D.

customer.id <= is this customer id an int?

=convert.toint32(rd[0].tostring) <= your trying to convert an array of customer ids to an int?

I'm not sure elaborate on this subject. If your seeing this message it's because you have a string value somewhere, you might need more converts or something.