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:
|
|
|
|
No Response found!
|
|
|
|
|