Getting Database data into an array

Sign in to answer this question.

• SV

  sachi vasishta17y agoPosted May 26, 2009, 6:34 AM

  thanks Rodick
• RW

  Rodick Wu17y agoPosted May 26, 2009, 5:19 AM

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

  Rodick Wu17y agoPosted May 26, 2009, 5:17 AM

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

  Rodick Wu17y agoPosted May 26, 2009, 5:15 AM

  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(0,str.Length-1); } string arrays=str.split(',');