Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Access columns in ItemDataBound event when the datasource is Linq

Tags:

c#

asp.net

linq

Im setting the the datasource with the following code:

    protected void Page_Load(object sender, EventArgs e)
    {
        var vacancies = from v in db.Vacancies
                    join c in db.Customers on v.CustomerID equals c.CustomerID
                    join cp in db.CustomerPortals on c.CustomerID equals cp.CustomerID
                    where cp.PortalID == Master.Portal.ID
                    select new
                    {
                        Title = v.Title,
                        Internship = (v.ContractID == 6),
                        Hours = v.Hours,
                        City = v.Customer.City.Name,
                        Degree = v.Degree.Title,
                        Contract = v.Contract.Title,
                        CustomerID = v.CustomerID
                    };
        rVacancies.ItemDataBound += new RepeaterItemEventHandler(rVacancies_ItemDataBound);
        rVacancies.DataSource = vacancies;
        rVacancies.DataBind();
    }

Now i want to know how i can access 1 of the columns (like CustomerID) from the ItemDataBound event.

    void rVacancies_ItemDataBound(object sender, RepeaterItemEventArgs e)
    {
         // This doesnt seem to work, row would be null even though e.Item.DataItem has a value.
         DataRow row = (DataRow)e.Item.DataItem;
    }

I have figured out that e.Item.DataItem contains all the fields from my query and the type of e.Item.DataItem is

f__AnonymousType8<string,bool,byte,string,string,string,long>
like image 669
Fabian Avatar asked Sep 24 '09 10:09

Fabian


2 Answers

Finally found it, was as simple as the following:

long customerID = long.Parse(DataBinder.Eval(e.Item.DataItem, "CustomerID").ToString());
like image 126
Fabian Avatar answered Nov 13 '22 05:11

Fabian


This .Net 4.0 approach is also very cool indeed!

public void PersonDataBound(object sender, RepeaterItemEventArgs e)
{
    if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
    {
        dynamic person = e.Item.DataItem as dynamic;

        string name = person.Name;
        int age = person.Age;
    }
}

All Credit To: http://www.kristofclaes.be/blog/2010/08/12/anonymous-types-and-the-itemdatabound-event/

Because the page now shows an Error 404, here is the page from the Wayback Machine: Anonymous types and the ItemDataBound event (Archived version)

like image 29
RobD Avatar answered Nov 13 '22 06:11

RobD