Return list of values c#

Question

I'm new in Asp and I develop all querys with stored procedures:

I have a method like this:

  Filler.Fill(new PeriodoLogic().lstConsultaParcial(tabla).ConvertAll(o => (object)o), ref this.radcmbPeriodo, "nPeriodo", "nPeriodo", true);

lstConsultaParcial Method:

 public List<object> lstConsultaParcial(object Entidad)
        {
            return new PeriodoData().lstConsultaParcial(Entidad);
        }

View:

<td><telerik:RadComboBox runat="server" ID="radcmbPeriodo" Width="200px" MarkFirstMatch="true" Filter="Contains" DropDownAutoWidth="Enabled"                    
                    EmptyMessage="Seleccionar" ></telerik:RadComboBox></td>    
                     <td><asp:RequiredFieldValidator ID="rfv" runat="server" ErrorMessage="<b class='red'>Requerido</b>" ControlToValidate="radcmbPeriodo"></asp:RequiredFieldValidator></td>

It fills radcombobox, consulting a simple stored procedure, it receive values, 1,2,3,4,5,6,7,8,9,10,11,12 as:

Image

as you can see it returns values 1 to 12, so I think I dont need consult stored procedure, how can I send simple a list of 1 to 12 instead call stored procedure?

what if the values change in the database that your procedure uses? You will have the wrong data displaying then, — Sean T
– Sean T, Commented Dec 8, 2017 at 21:44

Adrian · Accepted Answer · 2017-12-08 21:44:18Z

1

Answer is simple. You don't want to call that function which goes to call the SP.

Using LINQ below, you can quickly generate a list of numbers from 1 to 12.

List<int> myList = Enumerable.Range(1, 12).ToList();
return myList;

This is what you need to return from the method that your Kendo control calls.

answered Dec 8, 2017 at 21:44

Adrian

8,6573 gold badges28 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user9065477 Over a year ago

But what code I need to change to return that list?

user9065477 Over a year ago

I try it as

List<int> myList = Enumerable.Range(1, 12).ToList();                         return new PeriodoData().lstConsultaParcial(myList);

, but it don't show anything.

CodingYoshi · Accepted Answer · 2017-12-08 22:03:07Z

0

You can generate it like this:

var nums = Enumerable.Range(1, 12).ToList();

edited Dec 8, 2017 at 22:03

answered Dec 8, 2017 at 21:44

CodingYoshi

27.3k7 gold badges68 silver badges76 bronze badges

1 Comment

D Stanley Over a year ago

You can remove .Select(x => x)

Collectives™ on Stack Overflow

Return list of values c#

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related