array into string[]

[altman]

Hello,
here is my vode:

***
ArrayList liste = new ArrayList();
SqlDataReader reader2 = macommande_mc.ExecuteReader();

string mc = "";

while (reader2.Read())
{
mc +=
reader2["VALUE_KEYWORD"].ToString() ;
liste.Add(mc);
}

I need to add all the values from my data reader into this:

string [] keywords = { "value1", "value2", "value3", "valueX" }

I tried this: string[] keywords = { liste.Tostring() } but it didn't work

Any idea?
Thanks,

 

[Hans Kesting]

altman laid this down on his screen :

Hello,
here is my vode:

***
ArrayList liste = new ArrayList();
SqlDataReader reader2 = macommande_mc.ExecuteReader();

string mc = "";

while (reader2.Read())
{
mc += reader2["VALUE_KEYWORD"].ToString()
;
liste.Add(mc);
}

I need to add all the values from my data reader into this:

string [] keywords = { "value1", "value2", "value3", "valueX" }

I tried this: string[] keywords = { liste.Tostring() } but it didn't work

Any idea?
Thanks,

string[] keywords = liste.ToArray(typeof(string));

should do the trick.

Hans Kesting

 

[altman]

No, unfortunately I've got an error:

Cannot convert ent le type 'System.Array' en 'string[]'.

I found this way:

while (reader2.Read())
{
mc += reader2["VALUE_KEYWORD"].ToString() + "," ;
}
reader2.Close();

int count = 1;
mc = mc.Substring(0, mc.Length - count);

string[] keywords = mc.Split(',');

altman laid this down on his screen :

Hello,
here is my vode:

***
ArrayList liste = new ArrayList();
SqlDataReader reader2 = macommande_mc.ExecuteReader();

string mc = "";

while (reader2.Read())
{
mc +=
reader2["VALUE_KEYWORD"].ToString() ;
liste.Add(mc);
}

I need to add all the values from my data reader into this:

string [] keywords = { "value1", "value2", "value3", "valueX" }

I tried this: string[] keywords = { liste.Tostring() } but it didn't work

Any idea?
Thanks,

string[] keywords = liste.ToArray(typeof(string));

should do the trick.

Hans Kesting

 

[Göran Andersson]

No, unfortunately I've got an error:

Cannot convert ent le type 'System.Array' en 'string[]'.

I found this way:

while (reader2.Read())
{
mc += reader2["VALUE_KEYWORD"].ToString() + "," ;
}
reader2.Close();

int count = 1;
mc = mc.Substring(0, mc.Length - count);

string[] keywords = mc.Split(',');

Well, that won't work if any of the values happened to contain a comma...

You just have to cast the result from the ToArray method, as it returns
an Object reference:

string[] keywords = (string[])liste.ToArray(typeof(string));


However, unless you are limited to using framework 1.1 you should not
use an ArrayList at all, use a strongly typed List<T> instead:


List<string> items = new List<string>();

while (reader2.Read()) {
items.Ass(reader2["VALUE_KEYWORD"].ToString());
}
reader2.Close();

string[] keywords = items.ToArray();

 

[Chris]

items.Ass(reader2["VALUE_KEYWORD"].ToString());}

Göran Andersson

items.Ass? I don't seem to recall that method!!

Chris

 

[Arne Vajhøj]

items.Ass(reader2["VALUE_KEYWORD"].ToString());}

Göran Andersson

items.Ass? I don't seem to recall that method!!

It is new method you can kick to get the program working !

Arne

 

[Göran Andersson]

items.Ass(reader2["VALUE_KEYWORD"].ToString());}

Göran Andersson

items.Ass? I don't seem to recall that method!!

Chris

It's for adding an item at the rear end of the list.

 

[Jeff Johnson]

items.Ass(reader2["VALUE_KEYWORD"].ToString());}

Göran Andersson

items.Ass? I don't seem to recall that method!!

[I have to add my own to thie list.]

It's a method for creating a back door....