How to return multiple strings from a MSSQL database in C#

Question

I was using this piece of code until i realized it only returns one piece of information. What is the correct method to use to retrieve multiple items?

sqlconn.Open();
SqlCommand cmd = new SqlCommand("Select [Description] from [dbo].[Categories] ", sqlconn);
string result = (string)cmd.ExecuteScalar();
Console.WriteLine(result);
sqlconn.Close();

I have this ready to take a part an Array i just cant find out how to get it to return an array.

foreach (var item in result)
{
    Console.WriteLine(item);
}

you are saving your result to a string, save your result to a list so you can loop through the results. use var result — Josh Adams
– Josh Adams, Commented Jan 7, 2019 at 19:15
That fixes the second problem but the main issue is ExecuteScalar() returns back only one item. I'm wondering is there a different function i could call anyone is aware of? — user5582406
– user5582406, Commented Jan 7, 2019 at 19:20
Thanks just figured it there , couldn't get it earlier for some reason thanks for the help though — user5582406
– user5582406, Commented Jan 7, 2019 at 19:26

Anderson Pimentel · Accepted Answer · 2019-01-08 00:16:57Z

4

ExecuteReader will return multiple items but you need to use a while loop to break down the results.

sqlconn.Open();
SqlCommand cmd = new SqlCommand("Select [Description] from [dbo].[Categories] ", sqlconn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
      Console.WriteLine(reader[0]);
}

edited Jan 8, 2019 at 0:16

Anderson Pimentel

5,8532 gold badges37 silver badges59 bronze badges

answered Jan 7, 2019 at 19:25

user5582406

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

2 Comments

Anderson Pimentel Over a year ago

No need for String.Format here. You can simply use: Console.WriteLine(reader[0]);

user5582406 Over a year ago

Very true, just had it left in from what i was doing , Edited.

Collectives™ on Stack Overflow

How to return multiple strings from a MSSQL database in C#

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related