how to get values from DB and add those in array in C# [duplicate]

Question

I was googling for and found no results for this. most of the people declare the array inside the void. like this

private void Something(){
                ArrayList list = new ArrayList();
                list.Add("awdawd");
}

but I have to declare the array outside of it because it would be used from different voids. this is my code:

 public string[] Names= { "Rick", "Morty", "John" };

and for the db:

 private void GetNames() {

        string cmdText = "SELECT * FROM Login";

        // using (SqlConnection cnn = new SqlConnection("Server=.\\SQLEXPRESS;Database=TestDB"))
        using (SqlCommand SelectCommand = new SqlCommand(cmdText, connectionstring))
        {
            SqlDataReader myReader;
            connectionstring.Open();
            myReader = SelectCommand.ExecuteReader();

        }

    }

I tried to make it Names.add("Mario"); but it didnt work.

any suggestion?

Do you want to add those name to the predefined ones or replace the initial array with the values from the database? Arrays don't have an Add method. If you want to use Add, use a List<> instead of an array. — Manfred Radlwimmer
– Manfred Radlwimmer, Commented Jan 25, 2017 at 12:36
You should learn the difference between string array and ArrayList — Pikoh
– Pikoh, Commented Jan 25, 2017 at 12:36
Btw, it's not a void but a method (that doesn't return anything). Your method GetNames should either return something(f.e. a string[]) or get a different name — Tim Schmelter
– Tim Schmelter, Commented Jan 25, 2017 at 12:41

Manfred Radlwimmer · Accepted Answer · 2017-01-25 12:38:00Z

0

You can resize the array to add a new element to it, but it's better to use List<string> in your case.

public List<string> Names= new List<string>(){ "Rick", "Morty", "John" };

and then you can add

Names.Add("Mario");

edited Jan 25, 2017 at 12:38

Manfred Radlwimmer

13.4k13 gold badges55 silver badges65 bronze badges

answered Jan 25, 2017 at 12:37

kgzdev

2,9312 gold badges21 silver badges37 bronze badges

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

4 Comments

berg96 Over a year ago

thanks, this worked. but how can I find the maximum number of values inside the String Array? for the old one I used Names.Length

kgzdev Over a year ago

Names.Count() will give you result

Eric Burdo Over a year ago

Check the Names object. There should be a property that makes sense to have the count. Probably Count is what you want... just poke around the properties to see what makes sense.

berg96 Over a year ago

yes. Names.Count works. thanks

Collectives™ on Stack Overflow

how to get values from DB and add those in array in C# [duplicate]

1 Answer 1

4 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Linked

Related