Interested to Buy Any Domain ? << Click Here >> for more details...
what is Execute NOn Query?
- 29 Answers
- 67769 Views
- Infosys, Protech, Sars Systems, SwanSoft Technologies, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
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 |
Answer / seenivasagan
exeuate non Query DataBase Used in Insert,UpDate,Delete...
| Is This Answer Correct ? | 10 Yes | 3 No |
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 |
Can I use One Data Set for More than one Data Adapter?
Define Execute Reader?
what is execute scalar?
11 Answers Atharva Infotech, Dohatec New Media, Make eIT, Protech,
What DataReader class do in ADO.NET ?
Explain the overview of ado.net architecture?
If we want to connect to many databases in dataaccess layer such as MSAccess,Sql server,oracle means not to a particular database depends on condition we have to connect to appropriate database in this scenario if we without changing code Ho wdo you handle this situation?
What are relation objects in dataset and how & where to use them?
What is meant by executenonquery?
What is sqldatasource?
What is shadow copy?
If a table contains 20000 records . In a page at each time 100 records to be displayed what are the steps you will take to improve performance? Will you use dataset or datareader?
Do you use stored procedure in ado.net?
-
Visual Basic (800) - C Sharp (3816)
- ASP.NET (3180)
- VB.NET (461)
- COM+ (79)
- ADO.NET (717)
- IIS (369)
- MTS (11)
- Crystal Reports (81)
- BizTalk (89)
- Dot Net (2435)
- Exchange Server (362)
- SharePoint (720)
- WCF (340)
- MS Office Microsoft (6963)
- LINQ Language-Integrated Query (317)
- WPF (371)
- TypeScript (144)
- Microsoft Related AllOther (311)
