Getting Table's Row Index Using LINQ

Question

Need to retrieve an index of a row in LINQ, then use that value to specify my DropDownList.SelectedIndex upon page load or postback.

    public String GetRoleName(Int16 RoleID)
    {
        SQL_TA_SCOREBOARDEntities1 c = new SQL_TA_SCOREBOARDEntities1();

        String qry = (from b in c.EmployeeAccessLevels
                      where b.id == RoleID
                      select b.Role).FirstOrDefault();

        return qry;
    }

I take the name of the Role for the dropdownlist to display but it doesn't work anyway.

            String RoleName = MyClass.RoleName(RoleID);
            ddlRole.Text = RoleName

So I really need the index instead.

Thanks in advance!

I think you're doing it wrong. Use ddl.SelectedItem to set selected item, not the index. — MarcinJuraszek
– MarcinJuraszek, Commented Apr 3, 2014 at 1:41

Programming Dreamer · Accepted Answer · 2014-04-03 02:47:19Z

2

I don't think retrieving a row's index is directly possible in LINQ.

You could just try

    ddlRole.Items[0].Text = RoleName

answered Apr 3, 2014 at 2:47

Programming Dreamer

2353 silver badges14 bronze badges

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

2 Comments

user3247075 Over a year ago

sorry for bothering on such a simple question :(

Programming Dreamer Over a year ago

It's ok we all start somewhere. :)

Collectives™ on Stack Overflow

Getting Table's Row Index Using LINQ

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related