ExecuteNonQuery executes a Transact-SQL statement against the connection and returns the number of rows affected.
vb.net command.ExecuteNonQuery()
C# command.ExecuteNonQuery();
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.
The following ASP.NET program insert a new row in Discount (Pubs database) table using ExecuteNonQuery();
Default.aspx
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head id="Head1" runat="server"> <title>Untitled Page</title> </head> <body> <form id="form1" runat="server"> <div> <asp:Button ID="Button1" runat="server" Text="Button" onclick="Button1_Click" /> </div> <asp:Label ID="Label1" runat="server" Text="Label"></asp:Label> </form> </body> </html>
Click the following links to see full source code
Advertisement