Results 1 to 3 of 3

Thread: Create and run the stored procedure

  1. #1
    Junior Member
    Join Date
    Feb 2007
    Answers
    1

    Exclamation Create and run the stored procedure

    Hai to all

    I wish to know how to connect the Stored Procedure(SQL Server) with ASP.net.


  2. #2
    Contributing Member
    Join Date
    Jun 2006
    Answers
    95

    Re: Create and run the stored procedure

    Quote Originally Posted by sm_amuda View Post
    Hai to all

    I wish to know how to connect the Stored Procedure(SQL Server) with ASP.net.
    Please read ADO.NEt book before asking such simple questions...

    here are few tutorials that might help...

    http://www.exforsys.com/content/category/17/221/266/

    http://www.exforsys.com/content/category/17/270/356/

    http://www.exforsys.com/content/category/17/269/354/


  3. #3
    Junior Member
    Join Date
    Jan 2007
    Answers
    2

    Re: Create and run the stored procedure

    I am giving an example to use a stored procedure in ASP.NET.
    Assume that I have written a SELECT command in a STORED PROCEDURE. By using DataAdapter in ASP.NET I want to display the data from the database table on to the datagrid.
    SqlConnection con=new SqlConnection(write servername,database name,uid,pwd);
    SqlDataAdapter cmd=new SqlDataAdapter("records",con);
    cmd.SelectCommand.CommandType=CommandType.StoredProcedure;
    Where "records" is a StoredProcedure.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact