ASP页面的存储过程重写？ [英] Stored Procedure Re-Write for ASP Page?

问题描述

我有一个存储过程，最初编写为从SSMS运行查询的部门负责人的状态更新。 它基本上是一堆查询和计算，而不是返回任何表，但是使用PRINT命令向控制台的消息窗口显示
各种数据库状态。

I想要将其迁移到网页。 我知道使用数据集和数据网格来显示表数据的基础知识，但是存储过程中没有表数据。 是否有类可以捕获
过程的文本输出并将其放在网页代码中？ 或者我是否正在重新编写代码以输出一个表以用作代码中的变量？

我的偏好是不更改代码以便可以从任一位置执行。

$

解决方案

< span style ="font-size：11.0pt; font-family：'Calibri'，sans-serif">嗨AltairWolfe，

欢迎来到MSDN论坛。

请参阅说明，您的问题是关于ASP.Net的开发，我们的论坛是讨论VS IDE。

我发现
a文档可能会给你一些想法，但是对于详细的开发问题，请重定向到这个适当的论坛：
https://forums.asp.net/ 寻求更好的支持，谢谢你你的理解。

最好的问候，

萨拉

I have a stored procedure that was originally written to be a status update for Department head who ran queries from SSMS.  It is basically a bunch of queries and computations that instead of returning any tables, but uses PRINT commands to show various database statuses to the message window of the console.

I want to migrate this to a web page.  I know the basics of using datasets and data grids to display table data, but there's no table data to be had from the stored procedure.  Is there a class available that can capture the text output of the procedure and just place it within the web page code?  Or am I looking at re-writing my code to output a table to use as variables in code?

My preference would be to not change the code so that it can be executed from either location.

解决方案

Hi AltairWolfe,

Welcome to the MSDN forum.

Refer to the description, your issue is about the ASP.Net development and our forum is to discuss the VS IDE.

I found a document that may be give you some ideas, but for the detail development issues, please redirect to this appropriate forum: https://forums.asp.net/ to seek for a better support, thank you for your understanding.

Best regards,

Sara

这篇关于ASP页面的存储过程重写？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！