单击按钮在窗体上显示存储的过程 [英] Display the stored procedure on a form on button click

问题描述

我想显示所选存储过程信息未执行或其他某种方式.我将在表单上显示存储过程的列表，用户可以在其中选择所需的内容，如果单击生成"按钮，我希望以网络表单的形式显示该存储过程的文本
样本图片
http://i.imgur.com/1143X.png [

I would like to display the selected stored procedure information not executing or some other kind. I will have my list of stored procedures displayed on the form where the user can select the required and if click on Generate button i would like to display the text of that stored procedure as it is on the web form
Sample Image
http://i.imgur.com/1143X.png[^]

推荐答案

您可以在ur中使用以下语句命令字符串:

exec sp_helptext Mystoredproc

----------------------------------

并将其显示在文本框或标签中

You can use the following statement in ur command string:

exec sp_helptext Mystoredproc

----------------------------------

and display it in a textbox or a label

这将为您提供帮助，

This will help you,

exec sp_helptext @storproc = ''stored_procedure_name''

这篇关于单击按钮在窗体上显示存储的过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！