Call stored procedure with SqlCommand : SqlConnection Stored Procedure « ADO.Net « C# / CSharp Tutorial






  1. C# / CSharp Tutorial
  2. ADO.Net
  3. SqlConnection Stored Procedure
using System;
using System.Data;            
using System.Data.SqlClient;  

  class Program
  {
    static void Main(string[] args)
    {
      SqlConnection thisConnection = new SqlConnection(
                @"Data Source=.\SQLEXPRESS;" +
                @"AttachDbFilename='NORTHWND.MDF';" +
                @"Integrated Security=True;Connect Timeout=30;User Instance=true");       
      thisConnection.Open();
      SqlCommand thisCommand = thisConnection.CreateCommand();
      thisCommand.CommandType = CommandType.StoredProcedure;
      thisCommand.CommandText ="TenRecoreds";
      SqlDataReader thisReader = thisCommand.ExecuteReader();
      while (thisReader.Read())
      {
        Console.WriteLine(thisReader["UnitPrice"]);
      }
      thisReader.Close();
      thisConnection.Close();
    }
  }








32.15.SqlConnection Stored Procedure
32.15.1.Call a stored procedure
32.15.2.Call stored procedure with no parameter
32.15.3.Call stored procedure with parameter and return value
32.15.4.Call storedprocedure and pass in the parameter
32.15.5.Call stored procedure with parameters using SqlCommand
32.15.6.Call StoredProcedure with input and output parameters
32.15.7.Catch exception when calling stored procedure
32.15.8.Retrieving a Return Value from a Stored Procedure
32.15.9.Retrieving a Stored Procedure Output Parameter
32.15.10.Retrieving Data Using a SQL Server Stored Procedure
32.15.11.Retrieves stored procedure parameter information
32.15.12.Call stored procedure
32.15.13.Call stored procedure with SqlCommand
32.15.14.Raising and Handling Stored Procedure Errors