Call storedprocedure and pass in the parameter : SqlConnection Stored Procedure : ADO.Net C# Examples

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

class  MainClass
{
        public  static  void  Main()
        {
                using  (SqlConnection  con  =  new  SqlConnection())
                {
                        con.ConnectionString  =  @"Data  Source  =  .\sqlexpress;Database  =  Northwind;  Integrated  Security=SSPI";
                        con.Open();

                        string  category  =  "Seafood";
                        string  year  =  "1999";

                        //  Create  and  configure  a  new  command.
                        using  (SqlCommand  com  =  con.CreateCommand())
                        {
                                com.CommandType  =  CommandType.StoredProcedure;
                                com.CommandText  =  "SalesByCategory";
        
                                //  Create  a  SqlParameter  object  for  the  category  parameter.
                                com.Parameters.Add("@CategoryName",  SqlDbType.NVarChar).Value  =  
                                        category;
        
                                //  Create  a  SqlParameter  object  for  the  year  parameter.
                                com.Parameters.Add("@OrdYear",  SqlDbType.NVarChar).Value  =  year;
        
                                //  Execute  the  command  and  process  the  results.
                                using  (IDataReader  reader  =  com.ExecuteReader())
                                {
                                        Console.WriteLine("Sales  By  Category  ({0}).",  year);
        
                                        while  (reader.Read())
                                        {
                                                //  Display  the  product  details.
                                                Console.WriteLine("    {0}  =  {1}",
                                                        reader["ProductName"],
                                                        reader["TotalPurchase"]);
                                        }
                                }
                        }

                }
        }
}