SQL Server ::trying To Use A Stored Procedure In My Codebehind Insted Of A Sqldatasource To Insert Some Data?

Nov 9, 2010

I'm trying to use a stored procedure in my codebehind insted of a sqldatasource to insert some data, and return the identity fields. But I keep getting tripped up on the output paramaters. What am I missing?

My code behind:

[Code]....

And, here's my stored procedure

Create PROCEDURE [dbo].[123]
(
@MatterToCloneID varchar(15),
@ClonedMatterID int OUTPUT,
@ClientIDOUT int OUTPUT,
@ExistingClientIDOUT int OUTPUT
)
AS
BEGIN
DECLARE
@ExistingClientID int,
@PendingClientID int,
@BillingAddress varchar(200),
@BillingCity varchar(200),
@BillingState varchar(100),
@BillingZipCode varchar(20),
@BillingCountry varchar(200)
SELECT @ExistingClientID = ExistingClientID, @PendingClientID = PendingClientID,
@BillingAddress = BillingAddress, @BillingCity = BillingCity, @BillingState = BillingState, @BillingZipCode = BillingZipCode, @BillingCountry = BillingCountry
FROM tNewMatters
WHERE MatterID = @MatterToCloneID
Set @ClientID = @EClientID
Set @PendingClientID = @PendingClientID
Set @BillingAddress = @BillingAddress
Set @BillingCity = @BillingCity
Set @BillingState = @BillingState
Set @BillingZipCode = @BillingZipCode
Set @BillingCountry = @BillingCountry
INSERT into tNewMatters
(MatterName, ClientID, PendingClientID, BillingAddress, BillingCity, BillingState, BillingZipCode, BillingCountry)
Values
('Enter Client Name', @ExistingClientID, @PendingClientID, @BillingAddress, @BillingCity, @BillingState, @BillingZipCode, @BillingCountry)
Select @ClonedMatterID = scope_identity()
Select @ClientIDOUT = @ClientID
Select @ExistingClientIDOUT = @ExistingClientID
END

View 3 Replies


Similar Messages:

SQL Server :: How To Write Stored Procedure For Insert Data & Execute It In MS SQL

Oct 13, 2010

How to write Stored Procedure for Insert Data & Execute it in MS SQL?

Some websites:

[URL]

View 4 Replies

DataSource Controls :: SQLDataSource And Tie A SqlDatasource To A Stored Procedure

May 14, 2010

I am trying to tie a sqlDatasource to a Stored Procedure. The stored procedure looks like...

[Code]........

View 2 Replies

SQL Server :: How To Create A Different Insert Stored Procedure.

Dec 14, 2010

[Code]....

I want create a stored procedure for insert values for Name,Company_Name,Designation,Eamil_Id,Remark then Ref_Id should automically get the value if insert in remain feilds like Name,Company_Name,Designation,Eamil_Id,Remark with out changing table structure

View 7 Replies

SQL Server :: Insert NULL Int Into Stored Procedure?

Jan 17, 2011

I'm strugling with this problem for quite some time and I've tried many different solution but nothing works. In my application there are 3 textboxes. First is mandatory but user can leave second and third empty. I that case I want that application insert NULL.

Here is .aspx code:

[Code]....

c# code:

[Code]....

Stored procedure:

[Code]....

I've tested code when user fills all 3 textboxes and it's working fine. If one second or third (or both) textbox(es) is(are) empty I wish to insert NULL into table. I've tried with DbNull.Value, null, 0, "3232131" and nothing works. I always get error Input string was not in a correct format. which is strange since code works when 2. and 3. tbs are filled and I'm not inserting string. And I've specified that table allows inserting of null values.

View 13 Replies

DataSource Controls :: Why Does Sqldatasource Not Return Data From Stored Procedure

Jun 8, 2010

i have a grid bound to sqldatasource control which gets its data from stored procedure. in page load event i code a dropdownlist where i take the selectedvalue parameter for the parameter query. only when a second dependant dropdownlist is selected (coded in dropdownlist1 selected event)is data returned ?

View 12 Replies

Forms Data Controls :: Calling Stored Procedure Sqldatasource Dropdownlist?

Mar 5, 2010

i try to fill datatextfield and datavaluefield through sqldatasource throuh calling soterd procedure,

but i don't get any value after running the application, here my code

[code]....

View 2 Replies

SQL Server :: How To Pass Parameters To Common Insert Stored Procedure

Dec 22, 2010

I would like to create a common stored procedure for all insert operations performed in my Database. So i created a stored procedure as below.

[Code]....

But now my problem is how to pass parameters for this stored procedure. I have got the column names of the table passed. But i would like to pass the parameters for each insert operation of each table to identify which value is passed for which parameter.

how to pass parameters for this stored procedure.

(Parameter can be Column name prefixed @ i.e. @Column name)

It is possible to get the column names in another Stored Procedure . But how to prefix @ for each column and pass this as parameter to the Common Insert Stored Procedure?

View 11 Replies

Forms Data Controls :: FormView EditItemTemplate DropDownList Loaded From Codebehind Via Stored Procedure?

Sep 3, 2010

I'm attempting to load DropDownLists from the C# codebehind as the FormView switches modes to Edit and displays the EditItemTemplate. I present the data in a FormView ItemTemplate using text boxes. When the user selects Edit, I have been attempting to load the EditItemTemplate dropdownlists by creating a dataset and binding it to the control, without success.

I've successfully loaded them in previous projects from within the .aspx code using <asp:ListItem> and within the C# code behind using Control.Items.Add(new ListItem), which are essentially the same thing of course . This project is different in that I want to get the data from a stored procedure on a MSSQL server.

In my latest attempt, I can see the data in the datasets. I'm getting "Error connecting to database.'eitRace' has a SelectedValue which is invalid because it does not exist in the list of items.Parameter name: value"

I include the code below. If someone could point me to an example I would be greatful. There has to be an elegant way of accomplishing this.

[code]....

View 3 Replies

How To Move Stored Procedure From SQL Server 2000 To 2005, Multiple Table Insert

Jul 21, 2010

moving some tables & stored procedures from SQL Server 2000, to SQL Server 2005.So far so good, but I've come across a problem with this stored procedure:

CREATE PROCEDURE [dbo].[user_insert]
@user_service_unit int,
@user_champion_1 varchar(50),
@user_champion_1_nt varchar(10),
@user_champion_2 varchar(50),
@user_champion_2_nt varchar(10),
@user_champion_3 varchar(50),
@user_champion_3_nt varchar(10),
@user_date_received datetime,
@user_requestor varchar(255),
@user_info_requested text,
@user_expiry_date datetime,
@user_10_days datetime,
@user_5_days datetime,
@user_2_days datetime
[code]...

View 3 Replies

How To Specify Parameter Value For Stored Procedure In SqlDataSource

Mar 16, 2011

Being new to using the declarative syntax of SqlDataSource I am trying to figure out a way to set the value of a parameter to a stored procedure. I have a Client_ID that is passed via the Request Object and I need to set the Client_ID before the stored procedure of the SqlDataSource is executed.

Does the stored procedure parameter have to be predefined in the ASPX markup or can it be added dynamically in the code-behind? Would anyone have an example that demonstrates the SqlDataSource markup with a stored procedure and parameter as well as setting that parameter value in code-behind?

View 1 Replies

Security :: Use A Dataset Stored Procedure To Insert Data

May 29, 2010

I am trying to insert a UserID column into a database table during membership creation. I have my tables set up in a dataset with the stored procedure in there. Now I am trying to call that stored procedure in the newuserwizard code and I it is not recognizing the stored procedure. I know it is because my dataset is not referenced in the newuserwizard code. Here is the code I am using:

[Code]....

The name of the stored procedure is "InsertUserID". I think I need to create a function that references the ataset but I am not sure how to do this..

View 6 Replies

ADO.NET :: Insert And Select Data From Stored Procedure Using Linq?

Jan 18, 2011

i do have a stored procedure which inserts data and the message should be displayed that data has been sucessfully updated or not

[code]....

View 8 Replies

Execute Stored Procedure Using Sqldatasource And Get Return Value In Vb.net?

Sep 15, 2010

How can I execute a stored procedure using sqldatasource and get the return value in vb.net.

View 2 Replies

SQL Server :: Have A Stored Procedure Execute Another Stored Procedure During Time Period?

Jan 28, 2011

I could probably figure this out if I tried to, but I have been working so long on code, I'm a little fried

I have a stored procedure, and I want to execute another stored procedure during a time period of lets say 1/1/2011 to 12/31/2011

How Would I accomplish this?

View 4 Replies

Best Way To Insert Values Multiple Times From Data Layer To Stored Procedure?

Feb 16, 2011

I have DAL Layer, from where invoking a stored procedure to insert values into the table.

E.g.:-

[code]....

Now as requirement changed, per client request i have to add values 5 times. So what is the best practice?

Do i call this Stored Procedure 5 times from my DAL?

View 4 Replies

C# - Accessing The Result Set Of A Stored Procedure, Executed Using SqlDataSource.Select?

Jul 21, 2010

I'm programming a webpage in ASP.NET which displays a list of students not listed as participants in something, and upon clicking a student name shows you a brief summary of their details, so the user can ensure they're selecting the right person.

My code currently correctly obtains their ID, adds it as a parameter to my stored procedure and executes the procedure;

[code]....

However, when I try to access the results I get the following error:

System.NullReferenceException: Object reference not set to an instance of an object.

Upon debugging, there don't seem to be any results returned... but when running just the stored procedure in SQL Server with the same data, it does return a single row, as expected.

How do I access this result so I can bind it to my fields?

(I am working in ASP.NET 3.5 in Visual Studio 2008, with SQL Server 2008.)

View 2 Replies

C# - Adding Parameter To Sqldatasource - Pass Them To Execute Stored Procedure

Mar 2, 2010

I am using a gridview where i am calling a stored procedure which has 4 input parameters. Out of these 4 parameters, values are to be given such that DomainId = This has to be the row which is to be deleted. This is a primary key Domain = This field has to be passed to SP as NULL. Description= This field has to be passed as NULL. OperationType= This field has to be passed by programmer as some static value say 4 How to i need to specify these here... More details of the Question are here.

<DeleteParameters>
<asp:ControlParameter ControlID="GridView1" Name="DomainId"
PropertyName="SelectedValue" Size="4" Type="Int32" />
<asp:Parameter DefaultValue="" Name="Domain" Size="16" Type="String" />
<asp:Parameter DefaultValue="" Name="Description" Type="String" />
<asp:Parameter DefaultValue="4" Name="OperationType" Type="Byte" />
</DeleteParameters>

On running my code using this. I gets an error

Procedure or Function 'spOnlineTest_Domain' expects parameter '@Domain', which was not supplied

View 2 Replies

DataSource Controls :: Catch An Error From A SqlDataSource Stored Procedure?

Sep 27, 2010

I have a stored procedure that creates a dynamic query. Sometimes the query is not built because there are no elements in the dynamic query. When the aspx page loads the SqlDataSource throws an error that the query is malformed. How can I catch this error, and handle it with a default message, before it returns the error to the aspx page?

View 2 Replies

DataSource Controls :: SqlDataSource, FormView, And Update With Stored Procedure In Code Behind

Sep 12, 2010

Using a FormView with a SqlDataSource, I'm attempting to Update data

by calling a stored proc in code behind. I was having trouble getting parameters

using Update Parameters in the SqlDataSource, but found a working solution by

coding the parameters.

The problem now is I'm getting an "Updating is not supported by data source 'XYZ' unless UpdateCommand is specified'.

View 3 Replies

SQL Server :: How To Create Stored Procedure In Sql Server 2005 And How To Use That Stored Procedure

Oct 1, 2010

I have created stored procedure and student database and also asp.net application for asp.net page but it could not found stored procedure what is the mistake actually I don't no

View 7 Replies

SQL Server :: Write Code Of Stored Procedure / Create Stored Procedure And Write Select Statement In It

Nov 23, 2010

how can I create stored procedure and write my select statement in it, I know how to create dataset then put type stored procedure and assign it to the sp ... what I want is writing my sp... how can I make it ?

check the following code, this is what I want to write put I don't know where or how !

CREATE STORED PROCEDURE SP_CATEGORY

@CATEGORY VARCHAR(30)

AS

BEGIN

SELECT LATIN_NAME, ENGLISH_NAME, ARABIC_NAME, CATEGORY

FROM FLORA, CATEGORY_LIST

WHERE FLORA.CATEGORY=CATEGORY_LIST.CATEGORY_NAME AND CATEGORY_LIST.CATEGORY_NAME IN (SELECT * FROM SPLITLIST(@CATEGORY, ','))

END

where can I write this code ?!

View 5 Replies

ADO.NET :: Insert Into Fails With Stored Procedure?

Feb 23, 2011

i have a web form to insert into sql server 2008 db with stored procedure.

my stoed procedure is
USE [dbCustomers]
GO
SET [code]....

the code-behind; [Code]....

i'm being able to insert into my db if i fill all the fields. But if i want to leave blank the date or marital status fields, it gives the following error;

String was not recognized as a valid DateTime. String was not recognized as a valid Boolean.

View 5 Replies

INSERT Stored Procedure Does Not Work?

May 18, 2010

I'm trying to make an insertion from one database called suspension to the table called Notification in the ANimals database. My stored procedure is this:

ALTER PROCEDURE [dbo].[spCreateNotification]
-- Add the parameters for the stored procedure here
@notRecID int,

[code]...

View 5 Replies

C# - Database Insert And Delete With Stored Procedure?

Jan 26, 2011

In my .aspx page, i have two textbox and one add button and one delete button.

I want simply, when entering data textboxes and click add button, adding to database with stored procedure.

When entering data textboxes and click delete button, delete from database with stored procedure.

How can I do that?

Simply I need 4 code part, add_click(), delete_click(), sp_add, sp_delete

View 1 Replies







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