c# - How to call a SQL Server stored procedure in asp file which returns a table -

i new asp.net. first created database in sql server 2008, , in it, created stored procedure getdata. want call stored procedure asp.net page.

in asp.net, have master page other page home, etc. want run getdata stored procedure when user clicks on home.

the stored procedure is:

create procedure getdata  begin    select * log_users end 

and home page code

<%@ page language="c#" masterpagefile="~/masterpage.master" autoeventwireup="true" codefile="default.aspx.cs" inherits="_default" title="untitled page" %>  <%@ mastertype virtualpath="~/masterpage.master" %>  <asp:content id="content1" contentplaceholderid="contentplaceholder1" runat="server">     <h2>this home page.</h2> </asp:content> 

and aspx.cs file code is:

public partial class _default : system.web.ui.page {     protected void page_load(object sender, eventargs e)     {         this.master.pagename = "home";     } } 

can me please?

var query = "yourstoredprocname"; var constr = configurationmanager.connectionstrings["stringname"].connectionstring; var con = new sqlconnection(constr); var cmd = new sqlcommand(query, con); cmd.commandtype = commandtype.storedprocedure; cmd.parameters.addwithvalue("@parametername", parametervalue); //if  //open connection - load result datatable con.open(); var reader = cmd.executereader(); datatable dt = new datatable(); dt.load(reader); con.close(); 

constr can either in format (using web.config stored connection string), or in raw string. i'd recommend way though. after runs you'll have datatable (dt) contains result of stored procedure, can manipulate please!

you can find connection string adding database data source project, , finding in data source properties (there may way this).