Answer / nandu

ExecuteNonQuery

Use: when we are talking about a single database record - in Update, Insert, Delete and Get by Id. In all these cases we can use input/output/input-output parameters. Please note that from the application architecture point of view it is also good practices when your Insert and Update stored procedure returns changed record exactly like Get By Id method does.

Conclusion

Always use ExecuteNonQuery except: when you have a set of records - use ExecuteReader and when you have a single output value that cannot be defined as a parameter - use ExecuteScalar. Hope this helped to clarify something.

Answer / mouli

Execute non Query is used to execute any SQL statement
(insert ,delete ,update) or a stored procedure

Answer / anuj katiyar

Return the no of affected roh in databse

Answer / pavan

This function is used to execute the DMLcommands. It return
int value resulting number of rows get affected.

Answer / parag

Execute non Query is used to execute more than one command
at the time like in DML command.

Answer / suman zalodiya

ExecuteNonQuery() is used when you run rhe query that
doesn't return anything.For example insert,update,delete
etc.

Answer / kamalakannan

update Request.QueryString aslo Execute non query

Answer / anna

it returns the no. of queries executed successfully

Answer / r

Execute NOn Query

List the 4 common ado.net namespaces?

0 Answers  

How to add a javaScript function in a datagrid?

0 Answers   C DAC, CDAC,

what purpose of Indexing creating? directly we can search the reqired row with the help of query?what is the use of indexing?

3 Answers  

What is the full form of ado?

0 Answers  

how to keep track of index in listbox items.

2 Answers  

What is the meaning of executenonquery?

0 Answers  

What is an ado?

0 Answers  

Explain the two fundamental objects in ado.net?

0 Answers  

Is datareader faster than datatable?

0 Answers  

Explain the differences between oledb sql server, oledbdotnet provider?

0 Answers  

How many commands does the oledbcommand takes?what are they?

2 Answers  

I am fresh graduate, trained in C# .net. How do i answer when interview ask me , Where do you see yourself within 5 years from now?

2 Answers