关于ASP.NET2.0编写扩展存储过程的问题-.NET教程,Asp.Net开发

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