Executequery and executescalar

Question

What is diff. Between executequery and executescalar. When i executing both i got 1 as a return value...

Hiren Soni · Answer

Executequery returns the number of rows affected by your sql query.. I think you wrote insert query to enter one record so i got output as 1 and executescalar returns the value of first column and first row.. It is mostly used in aggregate function. I think you dont know that. You wrote select query in it. And execute with executescalar..so you got first column and first row result and others column and row are neglected.thnx

Hiren Soni · Answer

Try this site Www.1000Projects.com where you find all language project readymade...in site further links available to other site which provides ready project

Kirtan Patel · Answer

CodeProject.com where you will find many projects in different languages

Janu · Answer

Anyone know in which i site i can get whole project

Janu · Answer

Thanx u all

Kirtan Patel · Answer

Friend Here is Clarification to your Question . ExecuteNonQuery() returns the Number of Rows Affected by Executing Query and ExecuteScalar() return Single Value that is Type Object . to use that value you need to do casting .