Specified cast is not valid in DataRow Casting

yoord · September 14th, 2004, 01:18 PM

hi every one i encountered with some thing like this when i fetch a record from database using ADO.NET and using below code

Code:

DataSet objDataSet=new DataSet();
objSqlDA_G.Fill(objDataSet,"counters");
SqlCommandBuilder objSqlComBuld=new SqlCommandBuilder(objSqlDA_G);
DataTable objDT_G=objDataSet.Tables["counters"];
DataRow objRW_G=objDT_G.Rows[0];
//This line cause InvalidCastException: Specified cast is not valid.
 

	Quote:
	
	
		
			
				quote:Application["counter"]=(Int32)objRW_G["count_all"]+100;

The count_all column type is bigint in data base i like to fetch it and increment and updating it.
any one help what i must to change.
Thanx In Advance.
YoOrD.

Beauty Is not onthe face
Beauty is on the heart
--<<Ghibran Khalil>>--

bmains · September 15th, 2004, 07:45 AM

Hey,

Probably should check for null value before you do anything with it:

if (!objRW_G.IsNull("count_all")) {
Application["counter"] ...
}

Brian

yoord · September 15th, 2004, 09:31 AM

it is no a null value error it is a casting error object and an integer.
Thanks for your reply.
Thanks In Advance .
YoOrD.

Beauty Is not on the face
Beauty is on the heart
--<<Ghibran Khalil>>--

stu9820 · September 15th, 2004, 10:22 AM

Try removing the +100 and see if it still gives you the same error.

yoord · September 15th, 2004, 10:30 AM

but i like to increment the value and update the value to data source
i put the 100 for examination purpose only and i like to increment the content value of the row and postback to DB and in other place remove or decrement the value of row.
Beauty Is not on the face
Beauty is on the heart
--<<Ghibran Khalil>>--

stu9820 · September 15th, 2004, 10:41 AM

What is the exact error?

I was thinking maybe you need to convert it int then add the 100 after the conversion.

yoord · September 15th, 2004, 12:19 PM

i want to fetch value from DB And Increment it and finally Update DB
to affect the value.
and i am using DataSet To Fetch Value And DataTable And DataRow Collection to display the value but how i can change the value of a Row using Casting or other style .
i am getting error when i am increment the value of a column of row
becuase it seems it is a class and not a proper value .
when i am using casting like this

Quote:

quote:

Quote:

(Int32)objRW_G["count_all"]+1;

i am get this error

Quote:

quote:

Quote:

Line 100: Application["counter"]=(Int32)objRW_G["count_all"]+1;
Line 101: }
Line 102:

Specified cast is not valid.

and i am getting confued how i can change specific row value.
Than for your reply.
Thanks in Advance.
YoOrD.

Beauty Is not on the face
Beauty is on the heart
--<<Ghibran Khalil>>--

yoord · September 15th, 2004, 02:33 PM

Hi every one can help me about this prolem.
i think i must cast it to int but it is not castable(!!!!?????)
any if have any idea guide me i am apperciate.
Thanks In Advance.
YoOrD.

Beauty Is not on the face
Beauty is on the heart
--<<Ghibran Khalil>>--

yoord · September 15th, 2004, 02:36 PM

Quote:

quote:Originally posted by stu9820
What is the exact error?

I was thinking maybe you need to convert it int then add the 100 after the conversion.

But i Cast it using this role (Int32)Row_g("cname");
But the problem persist and i dont know how i cast it to do this.

Beauty Is not on the face
Beauty is on the heart
--<<Ghibran Khalil>>--

yoord · September 15th, 2004, 02:38 PM

Thanks for your replies
but i know i hasn't Null

Quote:

quote:Originally posted by bmains
Hey,

Probably should check for null value before you do anything with it:

if (!objRW_G.IsNull("count_all")) {
Application["counter"] ...
}

Brian

Beauty Is not on the face
Beauty is on the heart
--<<Ghibran Khalil>>--