What is an execute nonquery in asp.net?

Asked by Last Modified  

4 Answers

Learn .Net

Follow 4
Answer

Please enter your answer

Shirish Kolekar

Experience Trainer for C, C++, .Net, Java, Python, Php, Networking

When you not expecting anything to be returned by the query then we use this method.
Comments
Dislike Bookmark

.Net Trainer

This method is used to fire INSERT/UPDATE/DELETE commands. Often we use we do not requires any value back from database.
Comments
Dislike Bookmark

Trainer

It is used to execute dml of SQL server
Comments
Dislike Bookmark

Trainer

The ExecuteNonQuery() performs Data Definition tasks as well as Data Manipulation tasks also. The Data Definition tasks like creating Stored Procedures ,Views etc. perform by the ExecuteNonQuery() . Also Data Manipulation tasks like Insert , Update , Delete etc. also perform by the ExecuteNonQuery()...
read more
The ExecuteNonQuery() performs Data Definition tasks as well as Data Manipulation tasks also. The Data Definition tasks like creating Stored Procedures ,Views etc. perform by the ExecuteNonQuery() . Also Data Manipulation tasks like Insert , Update , Delete etc. also perform by the ExecuteNonQuery() of SqlCommand Object. Although the ExecuteNonQuery returns no rows, any output parameters or return values mapped to parameters are populated with data. read less
Comments
Dislike Bookmark

View 2 more Answers

Related Questions

training
I am one of the TOP Trainer of this site with 12+ years of experience with coaching , Author of 14 books , Team leader in company and mentoring on the .NET platform. You can reach me here: shyam.rajput @ gmail . com
Mir
What is ASP.Net?
ASP.NET: Active Server Page .NET is a unified Web development model that includes the services necessary to build enterprise-class Web applications. ASP.NET is part of the .NET Framework. It's Microsoft product.
Geeta
If have more than 10 lac records in a table. Can any one tell how I can use custom paging in this scenario. Our motive to achieve records within 1-2 sec.
When you have such huge data(10 lac) client side pagination will kill your application and eventually will slow down. As mentioned above, server side pagination will be better approach. on demand click,...
JK IT Training

Hello Sir, I have little bit knowledge of C. Can I continue study Asp.net? Please advice..
for ASP.Net you need the basic programming knoladge in C and C++ OOP Method along with HTML,CSS, and Java Script. Because in ASP.Net Code behind C# is running. C# is based on Object oritented Methodology....
Mitu
0 0
8
What is .Net LINQ?
Hi Tina, Its a front end query like Sql to manipulate the collection of Data in C#.
Tina

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

Difference Between View Bag And View Data In Mvc
ViewData belongs to dictionary class whereas view bag is the dynamic object. i.e., dictionary class create objects that validate data for viewdata whereas dynamic object validates data for ViewBag.Also,The...

Suprio Dutta

0 0
0
Read CSV data using ODBC Connection
Codes to read the CSV data using ODBC Connection- Input File: File's Encoding format should be ANSI as below class Student{ public string CollegeId { get; set; } public string AdmissionDate...

Revan

0 0
0
ASP.NET Web API 2 action method return types
Here, in this article we will learn ASP.NET Web API 2 action method return types. A Web API 2 action method return types can be any of the following : Void HttpResponseMessage IHttpActionResult Other...

Sachin Tekriwal

1 0
0
CBSE Class12 math's chapter 3 matrices example 4 & 5
S

Shoba

0 0
0
CLR [ Common Language Runtime ] and it's properties
CLR is one of the components of the .NET framework which provides an environment to execute the .NET code or the managed code. , CLR helps in converting the MSIL/CIL code into native code and running...
R

Raga Deepthi G.

0 0
0

Recommended Articles

Why Should you Become an IT Consultant

Information technology consultancy or Information technology consulting is a specialized field in which one can set their focus on providing advisory services to business firms on finding ways to use innovations in information technology to further their business and meet the objectives of the business. Not only does...

Read full article >

8 Hottest IT Careers of 2014!

Whether it was the Internet Era of 90s or the Big Data Era of today, Information Technology (IT) has given birth to several lucrative career options for many. Though there will not be a “significant" increase in demand for IT professionals in 2014 as compared to 2013, a “steady” demand for IT professionals is rest assured...

Read full article >

Learn Hadoop and Big Data

Hadoop is a framework which has been developed for organizing and analysing big chunks of data for a business. Suppose you have a file larger than your system’s storage capacity and you can’t store it. Hadoop helps in storing bigger files than what could be stored on one particular server. You can therefore store very,...

Read full article >

Make a Career in Mobile Application Programming

Almost all of us, inside the pocket, bag or on the table have a mobile phone, out of which 90% of us have a smartphone. The technology is advancing rapidly. When it comes to mobile phones, people today want much more than just making phone calls and playing games on the go. People now want instant access to all their business...

Read full article >

Find .Net Training near you
.Net Training in Bangalore
.Net Training in Hyderabad
.Net Training in Pune
.Net Training in Chennai
.Net Training in Delhi
.Net Training in Mumbai
.Net Training in Noida
.Net Training in Kolkata
.Net Training in Gurgaon
.Net Training in Jaipur
Online .Net Training

Looking for .Net Training ?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you