how to get both values

Question

1.00/5 (1 vote)

See more:

, +

C#

var parametertaxitem = new SqlParameter("@taxitemid", SqlDbType.Int, (50));
parametertaxitem.Value = valu121;
parametertaxitem.Value = value22;
myCommand.Parameters.Add(parametertaxitem);

here i get last value of value22, i need both values of value121, and value22 how to get it.

Posted 30-Jul-12 2:12am

2011999

Updated 30-Jul-12 18:20pm

_Amy

v2

Add a Solution

Comments

Kenneth Haugland 30-Jul-12 8:14am

What do you mean value21 + value22 ?

pradiprenushe 30-Jul-12 8:19am

Why you want single parameter?

2011999 30-Jul-12 8:20am

add the table in value21,value22 row wise

2011999 30-Jul-12 8:21am

in my database table single parameter assign multiple values

_Amy 30-Jul-12 8:34am

Check my updated answer.!

Sandeep Mewara 30-Jul-12 10:46am

Why not define two parameters?

Kaushik Saha from Kolkata,India 31-Jul-12 1:35am

You can use store this two values in a table with different row

2 solutions

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)

Shahan Ayyub · Answer 1 · 2012-07-30T10:15:00

One way to work around is that you have to run your proc two times, one time with the value of "valu121" and in the next turn you will run the same proc with value "value22".

For example:

first time:

C#

           // assign paramater with value= valu121
           var parametertaxitem = new SqlParameter("@taxitemid", SqlDbType.Int, (50));
           parametertaxitem.Value = valu121;
           myCommand.Parameters.Add(parametertaxitem);

// run your proc and it will insert an entry in table with "tax_item_id" column = "valu121"

then in the second attempt run the same proc like:

C#

           // assign paramater with value= value22
           var parametertaxitem = new SqlParameter("@taxitemid", SqlDbType.Int, (50));
           parametertaxitem.Value = value22;
           myCommand.Parameters.Add(parametertaxitem);

// run your proc and it will insert an entry in table with "tax_item_id" column = "value22"

Hope it helps!

_Amy · Answer 2 · 2012-07-30T02:18:00

Solution 1

Hi,
According to your coding, you won't be able to get parameter value i.e. "value21", because "value22" is replacing the previous value of your parameter. You can use individual parameters to get and set bot parameters. Use this:
If you can use two parameters in your SP:

C#

//1st Parameter
var parametertaxitem1 = new SqlParameter("@taxitemid1", SqlDbType.Int, (50));
parametertaxitem1.Value = valu121;
myCommand.Parameters.Add(parametertaxitem1);

//2nd parameter
var parametertaxitem2 = new SqlParameter("@taxitemid2", SqlDbType.Int, (50));
parametertaxitem2.Value = value22;
myCommand.Parameters.Add(parametertaxitem2);

If you are using only one parameter:
Concatenate the strings using special character and split it in your stored procedure. Like:

C#

var parametertaxitem = new SqlParameter("@taxitemid", SqlDbType.Int, (50));
parametertaxitem.Value = valu121.ToString()+"±"+value22.ToString();
myCommand.Parameters.Add(parametertaxitem);

Now you are receiving both the values. Just split it in your stored procedure and use it. Like:

SQL

SET QUOTED_IDENTIFIER ON 
GO 
ALTER PROCEDURE [dbo].[ETIPSAVE_SP] 
    @taxitemid int , 
    @empid int, 
    @amount int , 
    @Etid int OUTPUT 
AS 
BEGIN
    DECLARE @taxitemid1 VARCHAR(10)
    DECLARE @taxitemid2 VARCHAR(10)
    SET  @taxitemid1 = substring(@val, 0,  charindex('±', @taxitemid ))--Finding first ID
    SET  @taxitemid2 = substring(@val, charindex('±', @taxitemid)+1, LEN(@taxitemid)) -- Findig second ID
    --Inserting the values
    INSERT INTO Employee_Tax_item_Payroll ( tax_item_id, emp_id, amount ) VALUES ( @taxitemid1, @empid , @amount ), ( @taxitemid2, @empid , @amount )
    SELECT @etid = @@Identity
END

All the best.
--Amit

Posted 30-Jul-12 2:18am

_Amy

Updated 30-Jul-12 18:18pm

v5

Comments

2011999 30-Jul-12 8:37am

SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[ETIPSAVE_SP]
(
@taxitemid int ,
@empid int,
@amount int ,

@Etid int OUTPUT
)
AS

INSERT INTO Employee_Tax_item_Payroll
(
tax_item_id,
emp_id,
amount
)

VALUES
(
@taxitemid,
@empid ,
@amount

)

SELECT
@etid = @@Identity

2011999 30-Jul-12 8:42am

where to change it

_Amy 30-Jul-12 8:51am

Use my updated answer's procedure..

Accept if it is working.. :)

_Amy 30-Jul-12 9:02am

What is this? Down-voted? Any problem with the coding?

2011999 31-Jul-12 0:14am

Msg 102, Level 15, State 1, Procedure ETIPSAVE_SP, Line 20
Incorrect syntax near '@@Identity'.

_Amy 31-Jul-12 0:19am

I missed end at the end of procedure. Try my updated answer. :)

Shahan Ayyub 31-Jul-12 1:25am

Have you run your solution ? it says "Failed to convert parameter value from a String to a Int32." since @taxitemid is type of int. Also @val is not defined.

_Amy 31-Jul-12 1:28am

Hey, You have not told anything about data-type. You should read "How to cast the types". Why you are working if you don't know how to use CAST in SQL Server. Simply downvoted, without understanding the question?

Shahan Ayyub 31-Jul-12 1:48am

used your suggested code example and your suggested procedure. I have pointed that you should provide correct details rather than involving asker into another issue as you can see asker could not resolve the error message. For your point related to casting and its understanding what i mean is not you don't know better or i know more than you, but as an expert provide appropriate and direct solutions. I can run your code but not sure if asker can. If any one has issue with solution they have right to down vote.

_Amy 31-Jul-12 1:53am

Right. But you can also edit the answer if you are facing the problem and you know the solution. anyway, not an issue. :)

Shahan Ayyub 31-Jul-12 2:20am

no idea who have down voted my 5 posts within one min or less ( How quick he/she is :) ). please suggest them to use "improve solution" link (if possible) since you are senior forum user.

_Amy 31-Jul-12 2:21am

I'll find your five answers and vote up. Don't worry. :)

Shahan Ayyub 31-Jul-12 2:30am

Issue is not to vote them up again issue is to find who have issues. I guess we should look other questions.