在Northwind数据库中定义的带参数的存储过程
create proc GetCustomersOrders
@CustomerId nchar(5)
as
select OrderId,OrderDate,RequiredDate,ShippedDate from orders where CustomerID=@CustomerID order by orderid
GO
在控制台应用程序中调用
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace procedure
{
class Program
{
static void Main(string[] args)
{
string dsn = @"server=.;database=Northwind;trusted_connection=true"; //连接数据库字符串
SqlConnection connection = new SqlConnection(dsn); //建立SqlConnection对象
SqlCommand command = new SqlCommand("GetCustomersOrders",connection);//建立SqlCommand对象
command.CommandType = CommandType.StoredProcedure; //指定类型为存储过程
SqlParameter param = new SqlParameter("@customerID", "AlFKI"); //建立SqlParameter对象,并传参数
command.Parameters.Add(param);
connection.Open();打开连接
SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);
while (reader.Read())
{
Console.WriteLine("{0} {1}",reader["orderID"],reader["OrderDate"]); //将数据显示出来
}
connection.Close(); //关闭连接
//Console.ReadLine();
}
}
}
create proc GetCustomersOrders
@CustomerId nchar(5)
as
select OrderId,OrderDate,RequiredDate,ShippedDate from orders where CustomerID=@CustomerID order by orderid
GO
在控制台应用程序中调用
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace procedure
{
class Program
{
static void Main(string[] args)
{
string dsn = @"server=.;database=Northwind;trusted_connection=true"; //连接数据库字符串
SqlConnection connection = new SqlConnection(dsn); //建立SqlConnection对象
SqlCommand command = new SqlCommand("GetCustomersOrders",connection);//建立SqlCommand对象
command.CommandType = CommandType.StoredProcedure; //指定类型为存储过程
SqlParameter param = new SqlParameter("@customerID", "AlFKI"); //建立SqlParameter对象,并传参数
command.Parameters.Add(param);
connection.Open();打开连接
SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);
while (reader.Read())
{
Console.WriteLine("{0} {1}",reader["orderID"],reader["OrderDate"]); //将数据显示出来
}
connection.Close(); //关闭连接
//Console.ReadLine();
}
}
}