Sunday, January 11, 2009

Call storedprocedure and pass in the parameter tutorial example

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

}
}
}

0 comments:

Followers

The Daily Puppy

 
Design by Wordpress Theme | Bloggerized by Free Blogger Templates | JCPenney Coupons