SqlPipe 类
C# 复制代码
[MicrosoftSqlServerServerSqlProcedure()]
public static void StoredProcExecuteCommand(int rating)
{
// Connect through the context connection
using (SqlConnection connection = new SqlConnection(context connection=true))
{
connectionOpen();
SqlCommand command = new SqlCommand(
SELECT VendorID AccountNumber Name FROM PurchasingVendor +
WHERE CreditRating <= @rating connection);
commandParametersAddWithValue(@rating rating);
// Execute the command and send the results directly to the client
SqlContextPipeExecuteAndSend(command);
}
以上存储过程的执行结果怎么样在ASPNET应用程序端来调用？
如果想把以上存储过程的返回结果体现在DataList控件中应用程序端的调用代码是什么样的？
;
