关于ASP.NET2.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控件中,应用程序端的调用代码是什么样的?

本文作者:
« 
» 
快速导航

Copyright © 2016 phpStudy | 豫ICP备2021030365号-3