CODEWITHSUNDEEP
c#asp.netlistviewdata-bindingdatarow
POIR
POIR

Reputation: 3190

Check if a column with a given name exists in a datarow

How can I check if a column exists in result that populate a listview? The listview is populated from a stored procedure.

This is what I tried but no success:

<%#  Container.DataItem.GetType().GetProperty("Phone")==null?"phone is null":"we have phone property" #>

or should I use e instead Container.DataItem ?

Upvotes: 8

Views: 24443

Answers (3)

Tim Schmelter
Tim Schmelter

Reputation: 460360

First, i would use codebehind if it's getting complicated (i use it almost always). Here i would use the ListView's ItemDataBound event which is triggered for every item:

protected void ListView1_ItemDataBound(object sender, ListViewItemEventArgs e)
{
    if (e.Item.ItemType == ListViewItemType.DataItem)
    {
        // assuming you have an ItemTemplate with a label where you want to show this
        Label lblInfo = (Label) e.Item.FindControl("LblInfo");
        DataRowView rowView = (DataRowView)e.Item.DataItem;
        if (rowView.Row.Table.Columns.Contains("Phone"))
        {
            lblInfo.Text = "we have the phone property";
        }
        else
        {
            lblInfo.Text = "no phone available";
        }
    }
}

That makes the code much more readable, maintainable, debuggable and type safe.

Upvotes: 15

POIR
POIR

Reputation: 3190

Also, I found a solution:

    public bool CheckProperty(string property_name)
    {

        try
        {
            Eval(property_name);
        }
        catch { return false; }
        return true;

    }

Upvotes: 0

Abhishek Shukla
Abhishek Shukla

Reputation: 666

You can check this in OnItemDataBound.

 protected void lstSample_OnItemDataBound(object sender, ListViewItemEventArgs e)
    {
        Label lblText = null;
        Boolean isColumnExists = false;
        if (e.Item.ItemType == ListViewItemType.DataItem)
        {
            DataRowView dr = (DataRowView)e.Item.DataItem;
            isColumnExists  = dr.DataView.Table.Columns.Contains("Hello");
            lblText = (Label)e.Item.FindControl("lbltext");
            if (isColumnExists)
            {

                lblText.Text = dr.Row["Hello"].ToString();
            }
            else
            {
                lblText.Text = dr.Row["Movies"].ToString();
            }
        }
    }

Hope this helps!

Upvotes: 3

Related Questions