Thursday, 20 June 2013

Execute Stored procedure using ADO.NET (C#)

Namespace used for execute the stored procedure,


using System;
using System.Data;
using System.Data.SqlClient;

public void SelectEmployee()
{
   SqlConnection con = null;
   SqlDataReader rd  = null;
   try
   {
         // Create and Open the SQL server connection object
       con = new SqlConnection("Database Connection string");
       con.Open();
     //  Create a command object and specify the Stored Procedure name and connection as well
       SqlCommand cmd  = new SqlCommand("ProcEmployeeDetails", con);
         //  Set the command object
       cmd.CommandType = CommandType.StoredProcedure;
         // Add parameter and value
       cmd.Parameters.Add(new SqlParameter("@EmployeeID", 550));
         // Execute the command
       rd = cmd.ExecuteReader();
       while (rd.Read())
       {
    Response.Write(rd["Name"].ToString(),rd["Age"].ToString(), rd["Designation"].ToString());
       }
    }
    catch (Exception e)
    {
          Response.Write(e);
    }
    finally
    {
       if (con != null)
       {
            con.Close();
       }
       if (rd != null)
       {
            rd.Close();
       }
     }       
}


0 comments:

Post a Comment

Topics

ADO .Net (2) Ajax (1) Angular Js (17) Angular2 (24) ASP .Net (14) Azure (1) Breeze.js (1) C# (49) CloudComputing (1) CMS (1) CSS (2) Design_Pattern (3) DI (3) Dotnet (21) Entity Framework (3) ExpressJS (4) Html (3) IIS (1) Javascript (6) Jquery (9) Lamda (3) Linq (11) Mongodb (1) MVC (48) NodeJS (7) RDLC (1) Report (1) Sql Server (29) SSIS (3) SSRS (2) UI (1) WCF (12) Web Api (10) Web Service (1) XMl (1)