Debugging a stored procedure from C# ASP.NET vs 2010

Question

0.00/5 (No votes)

See more:

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?

C#

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

Posted 9-Aug-16 14:55pm

Member 10744248

Updated 9-Aug-16 21:10pm

v4

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Hussain Patel · Answer 1 · 2016-08-09T16:32:00

Solution 1

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[^]

Posted 9-Aug-16 16:32pm

Hussain Patel

CHANDRA SEKHARA GUPTA · Answer 2 · 2016-08-09T21:10:00

SQL

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