specified cast is invalid

[arial]

Hi

I am new to programming. learning c# , asp.net.

write a simple program: to get the id from database and save it to arraylist to find the max(id).

and getting exception: Specified cast is invalid.

at line: int low = (int)arrm[i];

Appreciate any help.

Thanks

[r035198x]

Hi Plater ,

Thank so very much for all your help.

my first column is id and it is numeric datatype in sql database.

with your help I was able to solve my problem.

But Now, I got one more little issue. which is I am trying to do a query with like clause and i think I am not getting write syntax.

Need help with that please.

Select paperid from Allreport where paperid like ' "+DateTime.Now. ToString("yymm" )+%" ' ;

my paperid will be for this month. 070901,070902 depending on as many time report was modified by user and I like to get the all paperid for a perticular month.

thank you,

Try writing it as

+DateTime.Now.ToString("yymm") " + "%"

[arial]

Hi R,

No , that did not work either.

Thanks,

[Plater]

Hi R,

No , that did not work either.

Thanks,

What is it telling you now then?
"it doesn't work" is not a very helpful reply

This didn't work?

string sql="Select paperid from Allreport where paperid like ' "+DateTime.Now.ToString("yymm")+"%' ";
 

[arial]

I have value in id field but the query doesn't return any value.

No error but doesn't give any result.

Thanks,

[Plater]

Have you tried your query's in the sql query window for your sql server (ie not in code) too make sure they return something?

Select paperid from Allreport where paperid like '0709%'
 

if that statement in your sql query window returns no results then you don't have matching data.

[arial]

Ok, I saw the problem.

paperid is Numeric datafield in sql table. So, when value hits the database it removes the "0 " from front.

Ex , 070901 hits database it goes for 70901..

that's why query wasn't giving any result.

Any idea on how to have paperid store in database like 070901 and not 70901?

Thanks,

[r035198x]

Ok, I saw the problem.

paperid is Numeric datafield in sql table. So, when value hits the database it removes the "0 " from front.

Ex , 070901 hits database it goes for 70901..

that's why query wasn't giving any result.

Any idea on how to have paperid store in database like 070901 and not 70901?

Thanks,

The table design was wrong then.
Change the table column type to varchar2 whatever type that your database uses for strings.

[arial]

Thanks but then I need to increment id by1 each time the page will modify. If I will change the id to varchar then I need to store that query result some like in array or something where then convert to "Int".

How can I accomplish this? How can I store my query into array?

Thanks,