Call a store procedure

image_pdfimage_print
   

//Call a store procedure

/*
 * C# Programmers Pocket Consultant
 * Author: Gregory S. MacBeth
 * Email: gmacbeth@comporium.net
 * Create Date: June 27, 2003
 * Last Modified Date:
 * Version: 1
 */
using System;
using System.Data;
using System.Data.SqlClient;

namespace Client.Chapter_13___ADO.NET
{
    public class Callastoreprocedure
    {
        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);
            
        }
    }
}