Call a Stored Procedure

Question

2.00/5 (1 vote)

See more:

Any Hints where the error could be while trying to call a stored project.It returns a null whereby it should contain a ID.

C#

SqlConnection con = new SqlConnection(@"Data Source=FNUEXCPC01\SQLSERVER2005;Initial Catalog=Record_Management;Integrated Security=True");

con.Open(); 

SqlCommand cmdselect = new SqlCommand("RecordManagement_getcollegeid", con);
cmdselect.CommandType = CommandType.StoredProcedure;
cmdselect.CommandText = "RecordManagement_getcollegeid";

ddlistschools.SelectedValue);
cmdselect.Parameters.Add(new SqlParameter("@College",ddlistschools.SelectedValue));
              
cmdselect.Parameters["@OutRes"].Direction = ParameterDirection.Output;

int Results;          
Results = (int)cmdselect.ExecuteScalar();

Results should contain a ID

Posted 8-Aug-12 12:26pm

Member 9291223

Updated 8-Aug-12 14:10pm

Kenneth Haugland

v3

Add a Solution

Comments

Sergey Alexandrovich Kryukov 8-Aug-12 18:31pm

ddlistschools.SelectedValue); will not compile... what are you showing here?
--SA

Member 9291223 8-Aug-12 18:54pm

The stored procedure is like this:

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER PROCEDURE [dbo].[RecordManagement_getcollegeid]
@College nvarchar(max)
AS
Select College_ID
From College
WHERE College_Name = @College

AspDotNetDev 8-Aug-12 20:15pm

I am confused. I don't see an output parameter in that stored procedure, yet your C# code shows an output parameter. Please edit your question to include any code rather than posting it as a comment so we can all get a clear picture of what is going on.

Member 9291223 8-Aug-12 18:59pm

THis statement is a commented like:

cmdselect.Parameters["@OutRes"].Direction = ParameterDirection.Output;

1 solution

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)

AspDotNetDev · Accepted Answer · 2012-08-08T12:44:00

I can't give specific help unless I see the stored procedure contents, but here are some ideas off the top of my head:

Maybe ExecuteScalar is returning SqlInt32 rather than int.
Maybe you are supposed to be getting the value of the output parameter.
Maybe @College is being passed in as the wrong data type (e.g., maybe an int is expected, but maybe you are passing in a string).
Maybe you did something wrong and there are no records to return from the stored procedure based on the inputs you gave it.

Some ways you can solve this:

Log any calls (e.g., to a different table) to the stored procedure so you can run them yourself from SQL Server Management Studio.
Use SQL Profiler to see exactly what is being passed to SQL Server.
Set some breakpoints to be sure all your values are as you expect (e.g., ddlistschools.SelectedValue).