stored Procedure usage in ASP.NET

Question

I am using StoredProcedure in sqlserver 2005.

Stored Procedure:

create proc useGetASP @PartyCode nvarchar(50)
as
select * 
from partyRegister 
where PartyCode=@PartyCode
Go

I was trying to execute it with asp.net visual studio 2010.

By researching for code i came to know i should use

 cmd.CommandType = CommandType.StoredProcedure

But unfortunatly CommandType.StoredProcedure is not there , its not working.

Hence i used:

cmd.CommandType = SqlDataSourceCommandType.StoredProcedure;

But this is also not working. It shows me red line below it [As comes when we type something invalid]. As a tooltip it shows me error as: CommandType does not exists in current context

My Full Code:

con.Open();
cmd = new SqlCommand("useGetASP",con);
//cmd.CommandType =CommandType./*Not Working*/
cmd.CommandType = SqlDataSourceCommandType.StoredProcedure;/*Also Not Working*/
cmd.Parameters.AddWithValue("@PartyCode","0L036");

What is my mistake?

What command should i use for implementing stored procedure?

Please Help Me.

What error you are getting ??

Rajeev Kumar
– Rajeev Kumar

2013-05-13 07:33:17 +00:00
Commented May 13, 2013 at 7:33 — Rajeev Kumar
– Rajeev Kumar, Commented May 13, 2013 at 7:33
CommandType does not exists in current context

Freelancer
– Freelancer

2013-05-13 07:34:31 +00:00
Commented May 13, 2013 at 7:34 — Freelancer
– Freelancer, Commented May 13, 2013 at 7:34

Albireo · Accepted Answer · 2013-05-13 07:38:21Z

4

Try like this:

System.Data.CommandType.StoredProcedure

Source: http://msdn.microsoft.com/en-us/library/system.data.commandtype.aspx

edited May 13, 2013 at 7:38

Albireo

11.1k14 gold badges66 silver badges96 bronze badges

answered May 13, 2013 at 7:35

Amit Singh

8,12922 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Praveen Nambiar · Accepted Answer · 2013-05-13 07:39:30Z

3

First use this namespace

using System.Data;

Then you should be able to use:

CommandType.StoredProcedure

answered May 13, 2013 at 7:39

Praveen Nambiar

4,9022 gold badges24 silver badges32 bronze badges

Comments

Rajeev Kumar · Accepted Answer · 2013-05-13 07:37:56Z

2

Need to use like this

System.Data.CommandType.StoredProcedure

Also make it sure that Reference to System.Data is needed.

answered May 13, 2013 at 7:37

Rajeev Kumar

4,9739 gold badges53 silver badges91 bronze badges

Comments

Sunil · Accepted Answer · 2013-05-13 07:40:07Z

2

try using the namespace using System.Data;

answered May 13, 2013 at 7:40

Sunil

2,9255 gold badges36 silver badges42 bronze badges

Comments

Sain Pradeep · Accepted Answer · 2013-05-13 10:57:07Z

1

I think you are missing the blow line

using System.Data;

You need to use this namesapce for "SqlDataSourceCommandType.StoredProcedure" .

edited May 13, 2013 at 10:57

answered May 13, 2013 at 7:36

Sain Pradeep

3,1351 gold badge24 silver badges34 bronze badges

1 Comment

Sain Pradeep Over a year ago

Yeah it's my mistake. Thanks for your response.

Collectives™ on Stack Overflow

stored Procedure usage in ASP.NET

5 Answers 5

Comments

Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related