SqlPipe 類
C# 復(fù)制代碼
[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);
}
以上存儲過程的執(zhí)行結(jié)果怎么樣在asp.net2.0應(yīng)用程序端來調(diào)用?
如果想把以上存儲過程的返回結(jié)果體現(xiàn)在DataList控件中,應(yīng)用程序端的調(diào)用代碼是什么樣的?
http://www.survivalescaperooms.com/ASPNET2008/archive/2006/08/14/476478.html
新聞熱點(diǎn)
疑難解答
圖片精選