Populating DDL within a FormView

papadan · April 3rd, 2018, 01:00 PM

Okay, I got it working THIS way:

Code:

        var context = new HolyRollersEntities();
        var lst = (from x in context.tb_Decode
                    where x.DecodeNumber == 4
                    select new { x.DecodeID, x.DecodeDescription }).ToList();
      //  var lst2 = context.tb_Decode.Select(x => new { x.DecodeID, x.DecodeDescription }).ToList();
        ddl.DataSource = lst;

But I would still like to know how to shorten it using the one-liner I commented out (var lst2).

papadan · April 3rd, 2018, 01:19 PM

I've got this working and the Insert works too - except:

It doesn't populate the ArmorCategory field with the selection from the drop down list.

How do I bind the value that the user selects.
The DataValueField (DecodeID) is the one that I want inserted into the ArmorCategory field name - how does that work?

I can't say <%# Bind("DecodeID") %> because the field is called ArmorCategory in the tb_Equip_Armor table.

I can't say <%# Bind("ArmorCategory") %> because that's not the name of the DataValueField.

papadan · April 3rd, 2018, 01:37 PM

It's working now.

I used:

Code:

SelectedValue='<%# Bind("ArmorCategory") %>'

Imar · April 3rd, 2018, 01:43 PM

Excellent!

papadan · April 3rd, 2018, 03:09 PM

I appreciate all the help and feedback!

Could you tell me how I could've added a where clause to this statement below:

Code:

var lst2 = context.tb_Decode.Select(x => new { x.DecodeID, x.DecodeDescription }).ToList();

Imar · April 3rd, 2018, 03:30 PM

Just inject the Where before the Select:

var lst2 = context.tb_Decode.Where(x => x.Id > 22 && x.Approved).Select(x => new { x.DecodeID, x.DecodeDescription }).ToList();

That would bring back all approved items with an ID greater than 22 (I just made up the Id and Approved properties for this example).

Imar

Imar · April 3rd, 2018, 03:31 PM

And you're welcome, BTW. Glad you like it!

papadan · April 3rd, 2018, 05:24 PM

That's what I was trying to do - but now I see my syntax error.

I was attempting something like

Code:

.Where(x.DecodeNumber == 4).Select(etc...)

And even tried

Code:

.Where(x=>DecodeNumber == 4).Select(etc...)

If ONLY I had tried

Code:

.Where(x => x.DecodeNumber == 4).Select(etc...)

It works! Thanks!

Imar · April 4th, 2018, 03:13 AM

You may find the following link useful. I linked to it in my book, but it's easily overlooked: https://docs.microsoft.com/en-us/dot...syntax-in-linq