How to execute StoredProcedure using SqlDataSource in asp.net
GridViewStoredProcedure.aspx
<%@ Page Language="C#" AutoEventWireup="true" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <script runat="server"> </script> <html xmlns="http://www.w3.org/1999/xhtml" > <head id="Head1" runat="server"> <title>How to execute StoredProcedure using SqlDataSource in asp.net</title> </head> <body> <form id="form1" runat="server"> <div> <h2 style="color:Navy; font-style:italic;">GridView Example: Execute StoredProcedure</h2> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>" SelectCommand="GetProducts" SelectCommandType="StoredProcedure" > </asp:SqlDataSource> <asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1" AutoGenerateColumns="true" AllowPaging="true" PageSize="10" BorderColor="Salmon" Font-Names="Comic Sans MS" Width="650" > <HeaderStyle BackColor="IndianRed" ForeColor="Snow" Height="45"/> <RowStyle BackColor="DarkSalmon" ForeColor="Snow" Font-Italic="true" /> <PagerStyle Height="45" HorizontalAlign="Right" BackColor="RosyBrown" Font-Bold="true" Font-Size="X-Large" ForeColor="Snow" /> <PagerSettings Mode="Numeric" /> </asp:GridView> </div> </form> </body> </html>
GetProducts [StoredProcedure]
CREATE PROCEDURE [dbo]. [GetProducts]
AS
SELECT PRODUCTID, PRODUCTNAME, QUANTITYPERUNIT, UNITPRICE FROM PRODUCTS


- How to set change DetailsView PagerSettings pager mode in asp.net
- How to select records using StoredProcedure and GridView in asp.net
- SqlDataSource - using SelectCommandType as StoredProcedure for select records
- Using CancelSelectOnNullParameter property in SqlDataSource in asp.net
- asp.net SqlDataReader example: how to use Read() method to populate ListBox
- asp.net ObjectDataSource example: how to populate DropDownList
- asp.net for loop example: using for loop
- How to use OnDeleted event in SqlDataSource for deleting records
- GridView TemplateField OnClientClick event -using confirmation message for deleting records