Return multiple values in C#

Question

How can I return multiple values from a class in C# I tried in the below way but it didn't work for me.

protected static string setvalues;
public static string myfunction()
{
        cmd = new SqlCommand("SELECT * FROM category", con);
        con.Open();
        SqlDataReader dr = cmd.ExecuteReader();
        while (dr.Read())
        {
            setvalues = dr[0].ToString();
        }
        con.Close();
        return setvalues.ToString();
}

I have the following in Categories table

Mobiles
Laptops
Cloths
DVD players
Televisions
Cameras

Anybody please help me in building a code that can return thousands of values.

You can't just return them as a string[] ? Or make it an ienumerable and use a yeild return. — Jess
– Jess, Commented Mar 11, 2012 at 4:29

SLaks · Accepted Answer · 2012-03-11 04:29:19Z

4

You want to return a List<String> (or an IEnumerable<string> using an iterator with yield return)

answered Mar 11, 2012 at 4:29

SLaks

891k182 gold badges1.9k silver badges2k bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Mad coder. Over a year ago

I am sorry, I never worked any of the above that you mention. Can you please provide me with its syntax?

moshbear Over a year ago

Doesn't .net 3 or .net 4 have a built-in tuple type so that SELECT * can return Tuple<...>[]? That is, an array of tuples instead of a vector of strings?

Bahamut Over a year ago

List<string> myList = new List<string>(); myList.Add("a string"); then return the list.

Mad coder. Over a year ago

@Bahamut - By trying your code I am getting output as 'System.Collections.Generic.List`1[System.String]'

Bahamut Over a year ago

to get the output from the list do a foreach. foreach(string strTemp in myList){ // do whatever to strTemp };

|

user1082916 · Accepted Answer · 2012-03-11 04:46:46Z

1

The List type in the C# language can solve above problem. With List, you do not need to manage the size on your own

    protected static List<string> listSetValues = new List<string>();
    public static List<string> myfunction()
    {
        cmd = new SqlCommand("SELECT * FROM category", con);
        con.Open();
        SqlDataReader dr = cmd.ExecuteReader();
        while (dr.Read())
        {
            listSetValues.Add(dr[0].ToString());
        }
        con.Close();
        return listSetValues;
    }

answered Mar 11, 2012 at 4:46

user1082916

2 Comments

Mad coder. Over a year ago

I am getting output as System.Collections.Generic.List1[System.String]`

user1082916 Over a year ago

You can simply import System.Collections.Generic namespace and can have access to all properties and method of List......

Uday0119 · Accepted Answer · 2012-03-11 04:41:09Z

0

Yes you can use Tuple class in .net 4.0. Forexample,

var population = new Tuple<string, int, int, int, int, int, int>(
                       "New York", 7891957, 7781984, 
                       7894862, 7071639, 7322564, 8008278);

OR
var population = Tuple.Create("New York", 7891957, 7781984, 7894862, 7071639, 7322564, 8008278);

For more information about properties and functions of Tuple class, visit Tuple Class on MSDN

answered Mar 11, 2012 at 4:41

Uday0119

7901 gold badge8 silver badges23 bronze badges

Collectives™ on Stack Overflow

Return multiple values in C#

3 Answers 3

6 Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related