c# - Retrieve data from SQL Server stored procedure into an array -

i'm trying data database , put array.

i tried code :

dataclassesdatacontext ds = new dataclassesdatacontext();  protected void page_load(object sender, eventargs e) {     list<string> _news = new list<string>();      (int = 0; <= 4; i++)     {         _news.add(ds.select_top_five_news().elementat(i).tostring());     } }     

but returns nothing of want , gives me error :

specified argument out of range of valid values.
parameter name: index

and stored procedure use:

create procedure select_top_five_news      return         select top 5 *         news         order newsid desc 

the problem stored procedure's result returned single result , need loop into each individual record

any please! or way same goal?

since procedure filtering data you, should have following. procedure return 5 results, whatever you've received you're getting. if need default entities, you'll have loop on , add missing items, not pull existing items out of results.

dataclassesdatacontext ds = new dataclassesdatacontext(); protected void page_load(object sender, eventargs e) {     var _news = ds.select_top_five_news().tolist(); } 

if using entity directly you'd this.

dataclassesdatacontext ds = new dataclassesdatacontext(); protected void page_load(object sender, eventargs e) {     var _news = ds.news.orderby(n => n.id).take(5).tolist(); }