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://m.survivalescaperooms.com/ASPNET2008/archive/2006/08/14/476478.html
新聞熱點(diǎn)
疑難解答
圖片精選