Home > Code > C# > Executing stored Procedure usign C#.NET

Executing stored Procedure usign C#.NET

by Thamilselvanj   on Dec 25, 2011   Category: C#   |  Views: 105    |  Points: 25   |  Silver 




The below c# sample used to execute sql server stored procedure and retrieving the data by using SqlDataReader.

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

public void ExecuteStoredProc()
{
SqlConnection objCon = null;
SqlDataReader objRdr = null;
try
{
objCon = new SqlConnection("...CONNECTION STRING....");
objCon.Open();
SqlCommand cmd = new SqlCommand("Stored_Proc_Name", objCon);
cmd.CommandType = CommandType.StoredProcedure;
objRdr = cmd.ExecuteReader();
while (objRdr.Read())
{
Response.Write(objRdr["Emp_Name"].ToString() + "<BR>");
}
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
finally
{
objCon.Close();
objRdr.Close();
}
}


Like this code? Bookmark and Share:

  User Responses | Post Code
 No Response found!
  Recent Posts
* Setting focus to textbox control using JavaScript (308) by Narain_Siddharth on Nov 13 2010 11:25AM
* Sending Mails with Attachements using Asp.Net (362) by Narain_Siddharth on Nov 13 2010 11:48AM
* Disable the Submit button when insert or update a record using JavaScript (278) by Narain_Siddharth on Nov 13 2010 12:31PM
* String comparisons using C#.NET string.compareTo (289) by Thamilselvanj on Nov 14 2010 11:16AM
* String.Split using C# (287) by Thamilselvanj on Nov 14 2010 11:23AM
  Submit feedback about this code snippet
Please sign in to post feedback