Getting Database data into an array

Question

int k = 0;

string[] alloTimeSlotsStr;

while (drr1.Read())

{

alloTimeSlotsStr[k] = drr1.GetValue(0).ToString();

k++;

}

giving me error

i want to get the values from database and put it inside string array how can i do it please help

sachi vasishta · Answer

thanks Rodick

Rodick Wu · Answer

It can't display the string tab after List please add it.

Rodick Wu · Answer

Of course you can return a list It's more easy List list=new List (); while (drr1.Read()) { list.Add(drr1.GetValue(0).ToString()); }

Rodick Wu · Answer

Because you don't setting the array's length when you define it So it occur error You can do as this: string str=string.empty; while (drr1.Read()) { str+= drr1.GetValue(0).ToString()+; } if(!string.isNullOrEmpty(str)) { str=str.Substring(0str.Length-1); } string arrays=str.split('');