Unable To Get Stored Procedure Output Variable Through ExecuteReader

Jan 10, 2011

here my code-

using (SqlDataReader sqlDataReader = ExecuteReader(CommandType.StoredProcedure, StoredProcedures.AuthenticateUser, sqlParameter))
{
isAuthenticated = Convert.ToBoolean(sqlParameter[2].Value);
if (isAuthenticated)
{
if (sqlDataReader.Read())
{
User = new UserEntity();
DbHelper.GetEntity(sqlDataReader, User);
}
}
}

I always get isAuthenticated as false because sqlParameter[2].Value is null all the time but when I execute my query with ExecuteNonQuery it gives me the value but in that case I can not fill the entity.

View 1 Replies


Similar Messages:

ADO.NET :: Can Pass A Value For A Output Variable In A Stored Procedure

Sep 7, 2010

I am calling a stored procedure, that exists in a SQL Server 2005 database, using ADO.NET, in which I instantiate a sql command object.

The stored procedure has an ouput variable like '@packageCode VARCHAR(100) = NULL OUTPUT'.

Can I set it's value when creating the sql command object? Or I can never set a value for an output type variable in a stored procedure?

View 5 Replies

ADO.NET :: Stored Proc With Output Parameters / Data In The Output Parameters From The Stored Procedure?

Mar 30, 2011

I have a stored procedure that works fine for classic asp, but how can I get my output parameters data back from in /MVC 2 / linq/ entities framework model . I have inported the function also, but when i try to code it i dont get results ...i know this is a matter of lack of / knowledge or exmple because i have been scouring the web for it and cannnot find into that accually works.

here is the stored proc.

[Code]....

Here was the one of the few tries I did:

[Code]....

but it executes fine does not give me an error, but also does not return the info i need to the viewmodel

I keep seeing stuff about "ref" on the net but "ref" shows " arbument # should not be passed with the ref keyword.

So i am not sure if there is a problem with the model, or with my understanding this, Now for your info I can do the same step with returning a dataset from a stored procedure fine, but I dont want a data set I just want excatly the data in the output parameters from the stored procedure.

View 2 Replies

Way To Get A String Output From Stored Procedure

Sep 29, 2010

i had a stored proc: How can i get the final select statement in the code behind.

ALTER PROCEDURE [dbo].[tgms_reclass_PO_bip](@po VARCHAR(20), @old_gl VARCHAR(20), @new_gl VARCHAR(20),@output varchar(500) out )
AS
IF (SELECT COUNT(*) FROM mm2po WHERE scode = @po) = 0
BEGIN
SET @output = '1'
SET @output = 'Invalid PO Number'
END
[code]...

View 4 Replies

How To Get Values Output From Stored Procedure

Oct 26, 2010

From this below stored Procudure, using VB.Net code can i get the Values like "Number of Rows Affected" and "Yes / No" Value from "Select"Stored Procudure:ALTER PROCEDURE [dbo].[lookup] @week_date datetimeAS

DECLARE @currweek datetime, @inweek datetime
IF @week_date = '10/14/2010'
BEGIN
UPDATE dbo.work_status SET ob_flag = 0, ob_update_date = NULL WHERE dbo.work_tatus.week_date ='10/14/2010'
SELECT 'YES'
END
ELSE
SELECT 'NO'
RETURN 0

View 3 Replies

SQL Server :: How To Add An Output Parameter To A Stored Procedure

Oct 7, 2010

how do I add an output parameter to a Stored Procedure that returns a code or string to the calling app

View 1 Replies

Way To Displaying SQL Stored Procedure Output Parameter Value

Jul 30, 2010

I am having some trouble with the below code snippet. It is a stored procedure which executes on load that has an output parameter which should display in a label. Familiar which Vb however not so much in C#.

View 2 Replies

DataSource Controls :: Way To Get Numeric Value In Stored Procedure As Output

Jun 4, 2010

i hav declare a Variable in stored procedure as@Total numeric(18,2) output..@Total Value is calculated 177.12 in stored procedure but when i return in Class.cs..its output is 177..

View 4 Replies

SQL Server :: How To Get Output As A Whole When Uasge Of Loop In Stored Procedure

Jul 19, 2010

I have written SP like this to get my required output.create procedure [dbo].[usp_gl_ProjectBudgets] set nocount on begin tran declare @SPError int

declare @y1 varchar(20)
declare @y2 varchar(20)
declare @y3 varchar(20)
declare @y4 varchar(20)
declare @y5 varchar(20)
declare @Glink int
declare @i int
set @y1='Year1'
set @y2='Year2'
set @y3='Year3'
set @y4='Year4'
set @y5='Year5'
set @Glink=1
set @i=1
[code]...

View 7 Replies

SQL Server :: Stored Procedure Output In Gridview Incorrect?

Feb 10, 2011

We had a simple Gridview that displayed a column list as Linkbuttons but we now need to display three columns as one, so I wrote a simple stored procedure to do it. However, the output in the Gridview shows duplicates and is not in order even though I specifySELECT DISTINCT in the result select as shown below.

ALTER PROCEDURE [dbo].[GetGeneralAction]
Add the parameters for the stored procedure here
AS
BEGIN
SET NOCOUNT ON;
CREATE TABLE #TempTbl (GeneralAction varchar(300) )
INSERT INTO #TempTbl (GeneralAction)
SELECT [General Action]
FROM [dbo].[Formulary2011]
INSERT INTO #TempTbl (GeneralAction)
SELECT [General Action2]
FROM [dbo].[Formulary2011]
[code]...

View 7 Replies

ADO.NET :: How To Define Date Output Parameters For A Stored Procedure

Oct 15, 2010

I have a question. How do we define date output parameters for a stored procedure?

before you answer,I should mention that I am not referring to the sql syntax definition ,which is @mydate datetime output.

This is ok,what i am asking is HOW DO I SPECIFY IT IN LINQ WHEN I NEED TO CALL THE STORED PROCEDURE IN THE SERVER SIDE CODE. I am repeating that I do I am not referring to the sql definition .

View 1 Replies

DataSource Controls :: Get The Output Parameter From Stored Procedure?

May 6, 2010

I have stored procedure that increments a number. I am supposed to use the newly generated number and insert it into a table. My question is how do I execute the stored procedure, with a hardcoded value of 3 that it expects as a paramter, receive the number it generates as the output parameter and use it in the insert statement.

Here is the stored procedure code:

CREATE PROCEDURE [dbo].[Generate]
@myid int,
@next_no int output
AS
update mytable
set mynumber=mynumber + 1, @next_no = number
where myid=@myid
RETURN

Here is my insert statement, that I tried and it failed:

EXEC @GetNo = Generate '3'
Insert into customers (custid, name, phone ) values
( @GetNo, 'MSFT', '800-345-5678')

View 5 Replies

SQL Server Email Stored Procedure Need To Send Table Like Output In The Body?

Jan 10, 2011

I am creating a nightly process using a stored procedure to check for expiring records and emailing myself and the folks that need to see the information. The trouble I am having is trying to send the data in table "like" view in the message body.Here is the Proc you can see the point at which i try to use a table vairble then use it as a parameter for calling the email proc but it doesn't seem to work.

View 5 Replies

DataSource Controls :: How To Return Multiple Output Parameter From Sql Server Stored Procedure

May 5, 2010

i want to return two output parameter n temp table from sql server stored procedure

View 6 Replies

SQL Server :: Declaring Variable In Stored Procedure?

Feb 16, 2011

I have this procedure

[Code]....

I don't know what variable should be put in where clause for tblVisitor.visitorID because there's a variable that was already passed by an output identity parameter by a different stored procedure. What will I put in the where clause for visitor id?

View 3 Replies

SQL Server :: Send NULL Value To A Stored Procedure Variable?

Sep 26, 2010

I want to send an image to a stored procedure variable that is varbinary(max) field, It works correctly when an image selected by fileupload and my image property has image file, and it can send to stored procedure. but when fileupload is empty I want to send NULL to stored procedure variable that is varbinary(max). I use DbNull.Value in C# code. But error occurs. What should I do for send Null to stored procedure?

View 3 Replies

DataSource Controls :: How To Use A Local Variable In Stored Procedure

Jan 18, 2010

I've created a SQL stored proc and want to change it to use a local variable to reduce process time..

Major lines of my SP:

[Code]....

I've been trying to use a variable for AVG(AA.Count) so that I don't have to process it three times,

[Code]....

=> this stored proc does not work, and I am not too sure where I should declare my local variable to use it in SELECT statement..

View 9 Replies

SQL Server :: Create XML Variable And Pass To Stored Procedure?

Aug 20, 2010

If I have the inventory class and want to make it to be xml and passed to web services and then web services will call stored procedure with xml as input parameters.

how to do in coding?

View 3 Replies

SQL Server :: Passing A Variable To A Remote Stored Procedure?

Feb 27, 2011

I have a SQL stored procedure on a SQL server that uses a variable to create a new database. This works in SQL I have a connection string that works I have added a sqldatasource to a webform, and configured the datasource to connect to the remote SQL database and am able to select my stored procedure. I am able to bind the variable to a control in the sqldatasource wizard (often two of the same control appear- if that is significant)

When I test the sqldatasource in the configuration wizard and put in a manual entry, the procedure runs and works

It is on the web page I am having troubles. I want the user to enter a name in a text box, click a button/link, and run the procedure. Ive used buttons and links...but not in the right way I think, becuase when I click them the stored procedure doesnt run.

As mentioned above, I have selected the right control in the sqldatasource wizard. So what do I need to do now?

Is it button click event? If so whats the syntax?

Should I be embedding my textbox in a dataview?

View 4 Replies

SQL Server :: Table Variable As Parameter For Stored Procedure?

Sep 9, 2010

My stored procedure expects a uniqueidentifier as a parameter. However, this unique identifier is stored in a table variable, which looks like this:

DECLARE @GiftGuid uniqueidentifie

View 14 Replies

DataSource Controls :: Using Table Variable In Stored Procedure?

Feb 18, 2010

I've written a stored procedure which uses a table variable. The stored procedure is shown below:

[Code]....

The table variable @CaseNumbers is declared, and is a bunch of values are inserted using a table-valued function called SplitStringIntoInts. At this point I can select from @CaseNumbers and this works fine.But when I try to join onto @CaseNumbers, the name '@CaseNumbers' in the ON clause is highlighted with the error 'Must declare scalar variable @CaseNumbers'. What?! It's not scalar, I declared it ages ago and I have used it since!

View 3 Replies

DataSource Controls :: Execute Stored Procedure Using A String Variable

Jun 22, 2010

Is it possible to save execute stored proc command in a string variable and then execute string variable?
Does this logic fits into LINQ2SQL? Why I want to do this - INstead of passing user control references to server, I want to save user control values to string in client side java script and then pass string to server to do actual stored proc execution. Hopefully this will improve performance.

View 3 Replies

SQL Server :: Assign Result Of Count Stored Procedure To C# Variable?

Aug 7, 2010

I have an aggregate stored procedure (named sp2) that returns a count of records meeting a certain criteria ASrecCount. I am using a DAL per the ASP.NET tutorial and have created a Table Adapter (named
sp2TableAdapter) with GetData and Fill methods. I have a button on an ASP.NET page that launches an event handler. In the button's event handler, I have this line: sp2TableAdapter sp2 = new sp2TableAdapter();
What works so far:

This code will bind the value of sp2 to a data control:

sp2TableAdapter sp2 = new sp2TableAdapter();
DropDownList1.DataSource = sp2.GetData();
DropDownList1.DataValueField = "recCount ";
DropDownList.DataTextField = "recCount";
DropDownList1.DataBind();

When running this page and clicking the button, the numeric value of recCount returned from sp2 is bound to the DropDownList control and 1 row is poplated with the recCount value (in my case 1451).

Problem:
In the event handler, I do not want to bind the value of recCount to a control, but want to to use it in some logic as an integer. What is the C# code that will do this? (In place of the DropDownList control lines above)

View 2 Replies

DataSource Controls :: Assign Value To A Variable From Exec In A Stored Procedure?

Apr 21, 2010

I have this SPDECLARE @PERC VARCHAR(50)

DECLARE @nome_soc_repl VARCHAR(50)
set @PERC = '(select round((' + @nome_soc_repl + ' /(select sum ('+ @nome_soc_repl+ ') from exptot_perc))*100,2)
from exptot_perc)'
EXEC (@PERC)
nome_soc_repl is a varible that contains my table name

so I need to extrac the result of EXEC...for examples 15...... and put it on another variable.....

View 4 Replies

ADO.NET :: Unable To Use Stored Procedure With LINQ With 8 Parameters

Jan 29, 2011

I am working on LINQ. I am calling a SQL Stored Procedure with 2-3 parameters it's working fine. When i am going to call Stored Procedure with 8 to 9 parameters the auto generated column is not comming automatically. So i am unable to use LINQ with Stored Procedure with multiple parameters.

View 4 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved