我希望从我的C#代码运行商店Proc,当用户点击按钮时,它会弹出相同的窗口,如SSMS,Execute Store Proc"并且用户可以输入参数。
I am looking to run store Proc from my C# code, and when user clicks button it popup same window like in SSMS, Execute Store Proc" and user can enter parameters.
是否可以?
谢谢
跳跃
推荐答案
你好,
您需要使用适当的控件创建表单,例如TextBoxes,DateTimePickers等获取参数信息。有一个按钮来执行,显示(如果有的话)导致DataGridView。
You would need to create a form with the proper controls e.g. TextBoxes, DateTimePickers etc to get parameter information. Have a button to execute, display (if any) results in a DataGridView.
不知道你对商店程序的了解,你可能想在MSDN上查看我的代码样本
Not knowing your knowledge of store procedures you might like to review my code samples on MSDN
code.msdn.microsoft/SQL-stored-procedures-1384f04c
更多推荐
如何弹出“Execute StorePro”窗口通过代码?
发布评论