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






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

class MainClass
{
  static void Main(string[] args)
  {
    SqlConnection cn = new SqlConnection("Data Source=(local); Initial  Catalog = MyDatabase; User ID=sa;Password=");
    SqlCommand cmd = new SqlCommand("MyStoredProcedure", cn);
    cmd.CommandType = CommandType.StoredProcedure;
    SqlParameter param = new SqlParameter("@ReturnValue", SqlDbType.Int);
    cmd.Parameters.Add(param);
    cmd.Parameters.Add("MyFirstParameter", SqlDbType.Int);
    cmd.Parameters.Add("MySecondParameter", SqlDbType.Int).Direction =
    ParameterDirection.Output;
    SqlDataAdapter da = new SqlDataAdapter(cmd);
    
  }
}








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