Mega Code Archive

 

Categories / C# Tutorial / ADO Net

 

Retrieving Data Using a SQL Server Stored Procedure

using System; using System.Data; using System.Data.SqlClient;     class Program     {         static void Main(string[] args)         {             string sqlConnectString = "Data Source=(local);Integrated security=SSPI;Initial Catalog=AdventureWorks;";             string sqlSelect = "uspGetEmployeeManagers";             SqlConnection connection = new SqlConnection(sqlConnectString);             SqlCommand command = new SqlCommand(sqlSelect, connection);             command.CommandType = CommandType.StoredProcedure;             command.Parameters.Add("@EmployeeID", SqlDbType.Int).Value = 100;             DataTable dt = new DataTable( );             SqlDataAdapter da = new SqlDataAdapter(command);             da.Fill(dt);             foreach (DataRow row in dt.Rows)             {                 Console.WriteLine(row["RecursionLevel"]);                 Console.WriteLine(row["EmployeeID"]);                 Console.WriteLine(row["LastName"]);                 Console.WriteLine(row["FirstName"]);                 Console.WriteLine(row["ManagerID"]);                 Console.WriteLine(row["ManagerLastName"]);                 Console.WriteLine(row["ManagerFirstName"]);             }         }     }