SQL Server :: Parameters From Codebehind For Returning Scope_Identity

Nov 17, 2010

I've used a sql data source to execute an insert stored procedure into my sql database. This time though, I want to execute the sp from my code behind. BUT, I'm stuck on the parameters and how to pass in the ones for the insert, and return one parameter, which is the identity of the row just inserted. The error I'm getting is. I'm missing something, but I don't see what... I think it's with the input/output parameters...
Procedure or function 'sp_CloneIT' expects parameter '@ClonedMatterID', which was not supplied. My stored proc

[Code]....

View 1 Replies


Similar Messages:

ADO.NET :: Scalar Entity Framework Stored Procedure Returning Scope_Identity()?

Nov 30, 2010

am new to entity frame work and having a hell of time building a stored procedure that insertsa value into a table using a Scalar stored procedure and returning the new ID which is a Unique Identifier. I am trying

[code]....

View 1 Replies

DataSource Controls :: Retrieve Scope_identity Value From Insert Statement In Codebehind

Jun 7, 2010

Iam inserting ,updating in one DBfunction .i want to retrieve identityvalue when in insert.for that am adding select SCOPE_IDENTITY() in insert statement.how i can i get this value??

public int funAddEdit_rtblIncidentTypesDB(clsCM_Inc_IncidentTypesData objData, int actiontype)
{
string qry = "";
if (actiontype == 1)
qry = "INSERT INTO _rtblIncidentType (cDescription,iEscGroupID,bAllowOverride,bRequireContract,iIncidentTypeGroupID,iWorkflowID,bAllowOverrideIncidentType,bPOIncidentType,cDefaultOutline) VALUES ('" + objData.cDescription + "'," + objData.iEscGroupID
+ ",'" + objData.bAllowOverride + "','" + objData.bRequireContract + "'," + objData.iIncidentTypeGroupID + "," + objData.iWorkflowID + ",'" + objData.bAllowOverrideIncidentType + "','" + objData.bPOIncidentType + "','" + objData.cDefaultOutline + "'); select
SCOPE_IDENTITY() ";
else if (actiontype == 2)
qry = "UPDATE _rtblIncidentType SET cDescription='" + objData.cDescription + "' WHERE idIncidentType=" + objData.idIncidentType;
int result = SqlHelper.ExecuteNonQuery(clsHelper.ConnectionString.ToString(), CommandType.Text, qry);
return result;
}

if i exceute the above query individually,it returns iddentity value,,bt unable to retireve the value in codebehind.

View 1 Replies

Selecting Returning Values From Sql Database In Codebehind And C#

Nov 2, 2010

Is there a way of selecting returned values from a call to an sql database in the code behind? For example assume that I used the following to select values from a table called Products;

SELECT Price, Qty, Numbersold FROM Products

How can I now get the returned values e.g. Price in the c# codebehind and display it in a textbox? I know that in the asp markup that I can use EVAL and Bind statements to do this for example I can do Eval("Price") but is there a way of getting any of the selected values (Price, Qty or Numbersold) in the codebehind?

I know that I can use three separate select statements and make three separate calls to return each value and then do something like the following

Price = Convert.ToInt32(myCommand.ExecuteScalar());

View 2 Replies

C# - Getting SCOPE_IDENTITY From SQL Server On Insert

Feb 7, 2011

I guess it is too late and I'm too tired to see what I'm doing wrong. Here is what I'm trying:

int imageId = imageDal.AddImage(new SqlParameter[]
{
new SqlParameter("@IMAGE_ID",
SqlDbType.Int, Int32.MaxValue, ParameterDirection.Output,
true, 0, 0,"IMAGE_ID", DataRowVersion.Current,DBNull.Value),
new SqlParameter("@IMAGE",
SqlDbType.Image, 11, ParameterDirection.Input,
true, 0, 0,"IMAGE", DataRowVersion.Current,image)
});
public int AddImage(SqlParameter[] spParams)
{
SqlHelper.ExecuteNonQuery(BaseDAL.ConnectionStringImages, INSERT_IMAGE_SQL, spParams);
return Convert.ToInt32(spParams[0].Value);
}
Stored Procedure:
[dbo].[sp_insert_image]
-- Add the parameters for the stored procedure here
@IMAGE_ID int OUT,
@IMAGE image
AS
BEGIN
INSERT INTO images
(IMAGE)
VALUES
(@IMAGE)
SELECT @IMAGE_ID = SCOPE_IDENTITY();
END
GO

I get DBNull as spParams[0].Value. I've tried setting value of @IMAGE_ID to a constant in my stored procedure yet it didn't change anything so the problem isn't with my stored procedure (that is what I think). When I execute the procedure from sql management studio, I see the inserted_id returning..

View 2 Replies

SQL Server :: SCOPE_IDENTITY() Always Returns 0?

Mar 3, 2011

I am trying to return the identity value of a inserted record for the first time in ASP.NET but it always returns 0, I can see in the database that a record is being inserted and the identity value is not 0.

Stored Proc:

[Code]....

Code Behind:

[Code]....

View 8 Replies

SQL Server :: ObjectDataSource And SCOPE_IDENTITY()?

Aug 6, 2010

I am using DetailsView attached to a ObjectDataSource to add a new record to a database. When it is complete I want to display the ID of the row that was added. I have a column in my database called ID that is set as the primary key and has Identity Specification enabled.
My Insert statement is:

{

View 3 Replies

SQL Server :: Stored Proc And Scope_identity

Aug 3, 2010

i have the following stored proc that inserts data into a database based on a stauts field. the first stored proc inserts into the first table and i am trying to get the identity field out as i need this value for the next stored proc. the first stored proc works fine and inserts the data but the secnd one doesnt, even though there is data there.

[Code]....

View 3 Replies

SQL Server :: Scope_Identity() Always Returns 0 And Not The Identity?

Oct 21, 2010

I have a Stored Proceedure which DID return the Scope_Identity when this was executed in SQLServer 2000.

Now I am porting this over to SQLServer 2008, and this always returns 0, and not the Scope_Identity which it should.

Here is the Stored Proceedure which will pass null for the parameter @pProjId for an insert:

[Code]....

Here is the script which creates the hip_Project Table:

[Code]....

What do I need to change for SQLServer 2008?

Again, this executed fine in SQLServer 2000 and always returned the Scope_Identity as expected. This problem has come up with other stored proceedures as well for which I need the Scope_Identity returned.

View 3 Replies

SQL Server :: Select Scope_Identity() Within BLL Table Adapter?

Jul 18, 2010

I am trying to add "Select Scope_Identity()" to my table adapter but vs2010 respond with "Unable to parse query text." error message.

Code for Insert SQL is -

INSERT INTO orders
(creditAutorizarionNumber, OrderName, OrderPersonPhone, OrderPersonEmail)
VALUES (@creditAutorizarionNumber,@OrderName,@OrderPersonPhone,@OrderPersonEmail)

I tried to add -

;Select Scope_Identity()

How can I use the Scope_Identity() withing a BLL table adapter ?

View 2 Replies

DataSource Controls :: Programmatically Adding Parameters To SQLdatasource In Codebehind Using C#

Apr 1, 2011

I have a page called Page2.aspx and it is called by another page called Page1.aspx and Page1.aspx passes two parameters namely: Name and Category to Page2.aspx. Does anyone know why the following code from Page2.aspx is not working and it keeps giving an error message as follows: " You have declare the parameter @Username".

string Cat1;
string Name1;

[Code]....

View 2 Replies

SQL Server :: What If Multiple Output Parameters And Input Parameters And Also Want A Select Table

Feb 16, 2011

[Code]....

When I want to get the output values its okay but I also want returning a table as a result data.But Datareader has no rows.is it possible if I want a returning query result and multiple output values togather ?I wrote a test above.I can get output values as sqlparameters. But Datareader attached to a Gridview is empty.can you detect whats wrong here and it doesnt return a query result.So stored procedure is not standart or ı am doing something wrong.this doesnt raise any exception.but not returning any data.

[code]....

View 8 Replies

C# - Is Returning List<T> From Method Differ In Performance From Returning Collection<T>?

Jul 18, 2010

We have a web project that contain its business methods in a class library project called "Bll.dll"
some methods of Bll.dll return List<> ... from a source - that i don't remember now - told that returning Collection<> is better than returning List<> Is it a valid ? Note that i don't make any process on values returned from BLL methods .. just view it in a web page

View 5 Replies

SQL Server :: Subquery Returning More Than 1 Value?

Sep 13, 2010

I have a problem regarding this code:

select NotificationID, (select u.UserName from aspnet_Users u, notifications n where u.UserId = n.FromID) as 'UserName', [Message], DateCreated, TypeID from Notifications n, aspnet_Users u

View 2 Replies

AJAX :: ISA Proxy Server Returning 407 For Request?

Feb 10, 2010

We are using 2 ISA proxy servers in front of our webserver and are getting intermittant Ajax errors in our application.

Our web logs indicate that there are 407 errors occurring during the requests.

When other users hit the webserver directly this issue does not occurr and this is also not an issue in IE8 but is in IE7.

The error dialog has Sys.WebForms.PageRequestManagerParserErrorException and the details say "error parsing near '<!DOCTYPE html P'

View 1 Replies

SQL Server :: Stored Procedure Not Returning Desire Value

Sep 28, 2010

I have simple stored procedure to check if there is any email address in the database entered by user or not. My SP should return 1 when user enters a correct email. However, it is returning 0 or -1.

View 3 Replies

SQL Server :: Group By Not Returning Expected Results?

Dec 17, 2010

I have a procedure that is used on a search page.. im trying to provide a highlevel resultset which you can then click on a record to view all records associated with it.

My expectation is to return 5 columns.. the ID and Date is what i want to group on.. so that if there are 10 records for ID=5 and Date=10/25/2010 then in my results i would have 1 record. Once im done with the page, you can then click on that line in the gridview to view the 10 records for that id. Does that make sense?

I have the following query, but for the criteria i entered, im getting back 3 records instead of just 2 since there is a differnet reboot count, BUT i really still just need overall data. so it should be only 1 record and seen below is what is returned and what is expected..

[Code]....

Here are the 3 records..

Currently returned

id Event Date Mount Errors Reboot Count J1939

225 11/01/2010 0 11 0

225 11/01/2010 0 11 0

225 11/01/2010 0 12 0

Expected returned

id Event Date Mount Errors Reboot Count J1939

225 11/01/2010 0 34 0

View 2 Replies

SQL Server :: Returning Backup File To Application?

Oct 11, 2010

I want send backup statement from my c# code to sql server then sql server return same back up file to my application in varbinary(max). what code is necessary for that?

View 3 Replies

SQL Server :: Returning Backup Files To Applications?

Oct 16, 2010

I want to send a backup command to sql server and return backup file to my c# application.

sql server is another machine and I have not access to its hard disk.

View 1 Replies

Web Forms :: Changing Codebehind In The Server?

May 26, 2010

I have a web forms app (3.5) deployed on a stage server (IIS 7).

I made a minor change to one of the pages code-behind. I was hoping that this change will come into effect next time I hit this page.

I closed all the sessions (browser) and reloaded the app, and visited the page I made the change. Still new code does not come into play.

So, I inserted a "throw new Exeption("test")" in page_load, hoping that the page will crash. Still the old code, no crash.

I wonder whether there is some kind of "caching" in IIS?

See here: [URL] (unfortunately no remedy here)

I amended the web.config (by adding an extra space), so that this will trigger a new compilation. Still old code is in effect.

Later, I added a simple text file to "bin" directory, hoping this will trigger a re-compilation. Still nothing.

View 3 Replies

VS 2008 Server.MapPath Returning Incorrect Path?

Apr 17, 2010

The layout of my web app is C:inetpubwwwroot<sln folder><web app folder>. So the image folder in my web app would be the previous path images.

When I try to save to my images folder from a FileUpload control and use Server.MapPath, it drops my <sln folder>, so the path is incorrect. How do I fix this? I figured Server.MapPath just moved up the folder until it hit a drive, no?

View 4 Replies

C# - Server.MapPath() Returning A Path That Does Not Exist When Used With DirectoryInfo?

Jul 20, 2010

I have a virtual directory setup in IIS6. This maps to a shared network drive.

I can correctly map the path using

string mappedPath = HttpContext.Current.Server.MapPath(path);

I then create a DirectoryInfo object as I want to find some files in the directory.

DirectoryInfo updateDirectory = new DirectoryInfo(mappedPath);

But then updateDirectory.Exists is false?? I can take the string from the mappedPath and copy into Start->Run to get to the path so I know it exists. I am authenticating to the webservice using integrated windows authentication and have permissions to the necessary folders.

Is there something obvious I'm missing in the code? Or is this purely set-up and configuration of IIS etc.?

View 2 Replies

Server.MapPath Not Returning Full Path Of A File?

Jan 10, 2011

I have image files stored in "VS_ProjectResourcesImages".

When I use the following code:

String str = Server.MapPath("a.png");
str becomes "VS_Projecta.png".

Why isn't it returning the full path?

View 1 Replies

SQL Server :: Playing With Stored Procedure And Returning Value To Parm

Nov 9, 2010

I been trying to get a simple stored procedure called and get its returned value back to a parm. In this case I am trying the simplest one I can make to get it to work and the I can build form there. I have tried to do this about 100 times and I try try and say heck with it and do it with out using a stored procedure and move on but I would really like to figure this out. I created a stored procedure called ReqLineItemTotal. It looks like this

USE [OnBillPROD]
GO
/****** Object: StoredProcedure [dbo].[ReqLineItemTotal]
Script Date: 11/09/2010 14:08:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- Author: Bill Blair
-- Create date: 11-9-2010
-- Description: ReqLineItemTotal
-- ALTER PROCEDURE [dbo].[ReqLineItemTotal]
-- Add the parameters for the stored procedure here
@SessionIDNo nvarchar(50) = 0

AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here select
(select SUM(dbo.TempReqDetail.Amount)
from dbo.TempReqDetail,dbo.tblReqAmountTypes
where dbo.tblReqAmountTypes.AmountType = dbo.TempReqDetail.AmountType and
dbo.tblReqAmountTypes.NumericOpperator = '+' and
dbo.TempReqDetail.SessionID = @SessionIDNo) -
(select SUM(dbo.TempReqDetail.Amount)
from dbo.TempReqDetail,dbo.tblReqAmountTypes
where dbo.tblReqAmountTypes.AmountType = dbo.TempReqDetail.AmountType and
dbo.tblReqAmountTypes.NumericOpperator = '-' and
dbo.TempReqDetail.SessionID = @SessionIDNo) AS LineItemTotal
END

From what I understand I should be getting my total back as LineItemTotal. So I want to call it pass it my parm of @SessionIDNo and have its returned value set to my @LineItemTotal parm. Trying to use these stored proc's always seems like way more work than they are worth but perhaps if I ever get the hang of it would make since to me.

View 6 Replies

SQL Server :: Returning A Certain Number Of Characters From A Database Entry

Feb 17, 2011

I have an entry from a database that has 500 characters. But when i display it i only want to return 200 charcters. How do I do that. I use Sql Server.

View 3 Replies







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