array

[frazer]

hi i am trying to use string arrays to store values from the db

string users="";
while (sqlDataReader.Read())
{
users = users+ sqlDataReader.GetString(1) + ",";
}
string [] users1 = users.Split(',');


rather than first use a string to store the roles and then put them in a
string array
is there a way to straight away put them in an array.thnx

 

[Julie]

hi i am trying to use string arrays to store values from the db

string users="";
while (sqlDataReader.Read())
{
users = users+ sqlDataReader.GetString(1) + ",";
}
string [] users1 = users.Split(',');

rather than first use a string to store the roles and then put them in a
string array
is there a way to straight away put them in an array.thnx

You can use ArrayList then to ToArray, or if you know how many elements are
going to be in the array, then you can just declare it at the beginning:

//ArrayList
ArrayList arr = new ArrayList();
//...
arr.Add(users + /*...*/);

string [] strs = (string[])arr.ToArray(typeof(string));

//known size
string[] strs = new string[num_elements];
//...
strs[index++] = users + /*...*/;

 

[Sherif ElMetainy]

Hello

If you know the number of records returned, you can allocate the array
before the loop.
You can know that with a "SELECT COUNT(*) FROM mytable", but you have to be
use locking or transactions because another process/thread may add or delete
records to the table
between the record count query and the loop.

Otherwise you can use ArrayList or StringCollection class.
If you must put in an array, you can use ArrayList's to array method.

Best regards,
Sherif