关于ASP.NET 2.0编写扩展存储过程

　    SqlPipe 类
  C# 复制代码
  [Microsoft.SqlServer.Server.SqlProcedure()]
  public static void StoredProcExecuteCommand(int rating)
  {
   // Connect through the context connection.
   using (SqlConnection connection = new SqlConnection("context connection=true"))
   {
   connection.Open();
  
   SqlCommand command = new SqlCommand(
   "SELECT VendorID, AccountNumber, Name FROM Purchasing.Vendor " +
   "WHERE CreditRating <= @rating", connection);
   command.Parameters.AddWithValue("@rating", rating);
  
   // Execute the command and send the results directly to the client.
   SqlContext.Pipe.ExecuteAndSend(command);
  
   }
  以上存储过程的执行结果怎么样在ASP.NET2.0应用程序端来调用？
  如果想把以上存储过程的返回结果体现在DataList控件中，应用程序端的调用代码是什么样的？
  
  http://www.cnblogs.com/ASPNET2008/archive/2006/08/14/476478.html 

查看本文来源