how to use return method more than one value

Question

0.00/5 (No votes)

See more:

C#

public string Insert_tmpStock_Card(tmp_Stock_CardBEL scbel, string Prod_code)
      {

          //Insert_tmpStock_Card
          if (cn.State != ConnectionState.Open)
              cn.Open();
          cmd.Connection = cn;

          cmd = new SqlCommand("SP_StockItem_Insert_tmpStock_Card", cn);
          cmd.CommandType = CommandType.StoredProcedure;
          cmd.Parameters.AddWithValue("@comp_id", scbel.Comp_id);
          cmd.Parameters.AddWithValue("@uid", scbel.Uid);
          cmd.Parameters.AddWithValue("@prod_code", Prod_code);
          dr = cmd.ExecuteReader();
          while (dr.Read())
          {
              tmp = dr["type"].ToString();
              transid = dr["sid"].ToString();
          }
          dr.Close();
          return tmp;


      }

here i want two values tmp,transid in presentation layer,but i can.t returning two values,only tmp value is getting,so plz help me to call two values

Posted 11-Sep-14 18:41pm

navya chowdary

Updated 11-Sep-14 18:42pm

v2

Add a Solution

Comments

Prasad Avunoori 12-Sep-14 0:46am

Hi Navya,

I have posted two ways one with out params and two with Key value pair in my solution below.

IpsitaMishra 12-Sep-14 0:46am

It is not possible to return 2 values from a method,but you can try other alternatives
1.Create 1 class with 2 properties and return that class from the method.
2.You can return 1 value and set 1 out parameters.

Hope this help you.

navya chowdary 12-Sep-14 0:52am

you have any example like that

george4986 12-Sep-14 1:03am

where u declare tmp,transid?
ur function return type is string?
plz post the calling code if possible

navya chowdary 12-Sep-14 1:21am

yes my function return type is "string",it declared string tmp="",transid="" in DAL,
IN PRESENTATION LAYER
tmp= skbll.Insert_tmpStock_Card(scbel, prodcode,tmp,transid);
transid= skbll.Insert_tmpStock_Card(scbel, prodcode,tmp,transid);

george4986 12-Sep-14 1:29am

check the solution it may work

IpsitaMishra 12-Sep-14 1:05am

Prasad Avunoori has defined the out parameter in a very nice way you can refer his answer.

Dukhabandhu Sahoo 12-Sep-14 1:40am

You can try Tuple (http://msdn.microsoft.com/en-us/library/system.tuple(v=vs.110).aspx) to return multiple values.

3 solutions

Solution 1

C#

public void Insert_tmpStock_Card(tmp_Stock_CardBEL scbel, string Prod_code,out  string tmp, out string transid)
      {

          //Insert_tmpStock_Card
          if (cn.State != ConnectionState.Open)
              cn.Open();
          cmd.Connection = cn;

          cmd = new SqlCommand("SP_StockItem_Insert_tmpStock_Card", cn);
          cmd.CommandType = CommandType.StoredProcedure;
          cmd.Parameters.AddWithValue("@comp_id", scbel.Comp_id);
          cmd.Parameters.AddWithValue("@uid", scbel.Uid);
          cmd.Parameters.AddWithValue("@prod_code", Prod_code);
          dr = cmd.ExecuteReader();
          while (dr.Read())
          {
              tmp = dr["type"].ToString();
              transid = dr["sid"].ToString();
          }
          dr.Close();
          
      }

Call the above method as below.

ClassName objClassName = new ClassName();

objClassName.Insert_tmpStock_Card(tmp_Stock_CardBEL scbel, Prod_code,out tmp, out transid)

After calling this method, you will be having two expected values in tmp, transid.

That's it!

Posted 11-Sep-14 18:44pm

Prasad Avunoori

Updated 11-Sep-14 19:28pm

v3

Comments

navya chowdary 12-Sep-14 0:49am

i want it for 3 tier architecture,and it read two values from stored procedure

Prasad Avunoori 12-Sep-14 0:55am

View my updated solution.

navya chowdary 12-Sep-14 0:59am

what is "ClassName" here

Prasad Avunoori 12-Sep-14 1:30am

In your presentation layer do like this:

string tmp,transid;
skbll.Insert_tmpStock_Card(scbel, prodcode,tmp,transid);

Don't call the method twice.

navya chowdary 12-Sep-14 1:41am

thanks for spending time for my sloution...

Solution 2

Ignoring other issues with your code, lets give a little tweak to your code gives you what you want.

C#

public void Insert_tmpStock_Card(tmp_Stock_CardBEL scbel, string Prod_code, out string type, out string transid)
      {
 
          //Insert_tmpStock_Card
          if (cn.State != ConnectionState.Open)
              cn.Open();
          cmd.Connection = cn;
 
          cmd = new SqlCommand("SP_StockItem_Insert_tmpStock_Card", cn);
          cmd.CommandType = CommandType.StoredProcedure;
          cmd.Parameters.AddWithValue("@comp_id", scbel.Comp_id);
          cmd.Parameters.AddWithValue("@uid", scbel.Uid);
          cmd.Parameters.AddWithValue("@prod_code", Prod_code);
          dr = cmd.ExecuteReader();
          while (dr.Read())
          {
              type = dr["type"].ToString();
              transid = dr["sid"].ToString();
          }
          dr.Close();
       }
}

If you can understand this is same what Prasad has said in Solution 1

Posted 11-Sep-14 18:56pm

_Asif_

Comments

navya chowdary 12-Sep-14 1:06am

what is difference between,string and out string

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)

george4986 · Accepted Answer · 2014-09-11T19:29:00

Solution 3

ur return type is string,its easy to use string functions
replace

C#

return tmp;

in ur code with

C#

return tmp+"~"+transid;

use split function of string to extract values
IN PRESENTATION LAYER (calling side)

C#

string result=skbll.Insert_tmpStock_Card(scbel, prodcode, tmp, transid).ToString();
tmp = result.Split('~')[0].ToString();
transid = result.Split('~')[1].ToString();

Posted 11-Sep-14 19:29pm

george4986

Updated 11-Sep-14 20:39pm

v2

Comments

navya chowdary 12-Sep-14 1:39am

thank you,can i use this for any number of values

george4986 12-Sep-14 1:46am

it is an easy fix ,string value can store upto 2 Gb.
refer this link
http://stackoverflow.com/questions/810797/which-is-better-return-value-or-out-parameter