Mega Code Archive

 

Categories / C# Tutorial / ADO Net

 

Call storedprocedure and pass in the parameter

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"]);                     }                 }             }         }     } }