what is Execute NOn Query?

Categories >> Software >> Microsoft Related >> ADO.NET
Suggest New Category

Question Posted / thirushakar

29 Answers
63906 Views
Infosys, Protech, Sars Systems, SwanSoft Technologies, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is Execute NOn Query?..

Answer / thirushakar

Execute non Query is used to execute more than one command
at the time (it is used for insert ,delete ,update)

Is This Answer Correct ?

235 Yes

38 No

what is Execute NOn Query?..

Answer / nvns

Execute Non Query(),is for insert,delete and update...
i.e for the statements which does'nt returns any value after
the execution.

Is This Answer Correct ?

120 Yes

20 No

what is Execute NOn Query?..

Answer / reshma

EXECUTE NON QUERY IS COMMAND OBJECT METHOD USED TO
INSRET,DELETE,UPADTE DATA INTO A DATABASE

Is This Answer Correct ?

57 Yes

10 No

what is Execute NOn Query?..

Answer / arvind nagar

Execute Non uery is used to perform catalog operations(i.e.
creating databse objcts such as tables) or to change the
data in database without using a dataset by executing
update, Insert and Delete operations.

Is This Answer Correct ?

57 Yes

15 No

what is Execute NOn Query?..

Answer / badmoon

Execute Non Query(),is for insert,delete and update...
i.e for the statements which does'nt returns any value after
the execution.

Is This Answer Correct ?

30 Yes

11 No

what is Execute NOn Query?..

Answer / usha

This method belongs to connection object.We call this
method to indicate that the stored procedure doesn't return
results for a query but rather than an integer indicating
how many rows are effected by the executed statement.

Is This Answer Correct ?

26 Yes

11 No

what is Execute NOn Query?..

Answer / anjeswar

it returns no of records updated and will be used for inert,
delete and updated operations

Is This Answer Correct ?

29 Yes

18 No

what is Execute NOn Query?..

Answer / seenivasagan

exeuate non Query DataBase Used in Insert,UpDate,Delete...

Is This Answer Correct ?

10 Yes

3 No

what is Execute NOn Query?..

Answer / hanna mae

You can use ExecuteNonQuery to change the data in a database
without using a DataSet. Do this by executing UPDATE,
INSERT, or DELETE statements.

Although ExecuteNonQuery does not return any rows, output
parameters or return values that are mapped to parameters
are populated with data.

For UPDATE, INSERT, and DELETE statements, the return value
is the number of rows affected by the command. For all other
types of statements, and for rollbacks, the return value is -1.

Is This Answer Correct ?

8 Yes

2 No

what is Execute NOn Query?..

Answer / venkat

this method is invoked whenever DMLcommands has
beenexcecuted

Is This Answer Correct ?

55 Yes

50 No