从C#ASP.NET vs 2010调试存储过程
问题描述:
需要从调用c#asp.net进入ms sql server存储过程。
我可以从c#应用程序然而它没有进入存储过程。
我怎样才能做到这一点?
need to step into an ms sql server stored procedure from a calling c# asp.net.
I can start debugging from c# application however it doesn't step into the stored procedure.
How can I accomplish this?
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
////
//GRIDVIEW1 BEGIN
try
{
//connection to the database
//
//
string str;
str = ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString;
SqlConnection sqlcon = new SqlConnection(str);
string intno;
//Get the intno
intno = GridView1.SelectedRow.Cells[1].Text;
//call the stored procedure
SqlCommand SqlCmd = new SqlCommand("sp_GetDisbursedt", sqlcon);
SqlCmd.CommandType = System.Data.CommandType.StoredProcedure;
//Supply the User_id parameter
SqlCmd.Parameters.AddWithValue("@ZAPPRAISAL", intno);
//Open the sql data connection
sqlcon.Open();
//Execute the stored procedures
SqlCmd.ExecuteNonQuery();
在项目的属性窗口中,我找不到
调试* 在左侧列表中。在应用程序下。
你怎么得到调试回来
请给出步骤。
谢谢
请协助
我尝试了什么:
我检查了互联网无济于事
In the project's properties window, I cannot find
"Debug* in the list on the left. Under Applications.
How do you get the "Debug" back
Pleae give the steps.
Thanks
Please assist
What I have tried:
I have checked the internet to no avail
答
这里是MSDN从Visual Studio调试存储过程的链接。
https://support.microsoft.com/en -us / kb / 316549 [ ^ ]
演练:调试Transact-SQL存储过程 [ ^ ]
here's the link from MSDN for debugging stored procedure from Visual Studio.
https://support.microsoft.com/en-us/kb/316549[^]
Walkthrough: Debug a Transact-SQL Stored Procedure[^]
Please debug your stored procedure in management studio like visual studio code debugging.
DECLARE @comname AS varchar(100)
DECLARE @commes AS varchar(100)
DECLARE @job AS varchar(50)
DECLARE @name AS varchar(200)
DECLARE @add1 AS varchar(200)
DECLARE @add2 AS varchar(200)
DECLARE @add3 AS varchar(200)
DECLARE @phone AS varchar(10)
DECLARE @fax AS varchar(100)
DECLARE @email AS varchar(100)
SET @comname =''
SET @commes =''
SET @job=''
SET @name =''
SET @add1=''
SET @add2=''
SET @add3 =''
SET @phone =''
SET @fax =''
SET @email =''
-- ALTER proc [dbo].[cards]
--(
-- @comname varchar(100),
-- @commes varchar(100),
-- @job varchar(50),
-- @name varchar(200),
-- @add1 varchar(200),
-- @add2 varchar(200),
-- @add3 varchar(200),
-- @phone varchar(10),
-- @fax varchar(100),
-- @email varchar(100)
--)
--as
begin
insert into card1 (comname,commes,job,name,add1,add2,add3,phone,fax,email)
values (@comname,@commes,@job,@name,@add1,@add2,@add3,@phone,@fax,@email)
end