ansaurus

Question

How would I search through a DataSet and change data in it before it gets bound?

Answer 1

+1 A:

If you're using a Repeater, or whatever datasource bound control, I would use the ItemDataBound event and set those values to your controls.

If this was your basic HTML

<html>
  <asp:Repeater id="repeater" runat="server" OnItemDataBound="repeater_ItemDatabound">
     <ItemTemplate>
         <span><%# DataBinder.Eval(Container.DataItem, "isScorm") %></span>
         <span id="totalLessonsSpan" runat="server"><%# DataBinder.Eval(Container.DataItem, "totalLessons") %></span>
     </ItemTemplate>
  </asp:Repeater>
</html>

I would have this in the code behind

protected void repeater_ItemDatabound(object sender, RepeaterItemEventArgs e)
{
    DataRow row = e.Item.DataItem as DataRow;

    if (row == null) { }
    else
    {
        int isScorm = 0;
        int.TryParse(Convert.ToString(row["isScorm"]), out isScorm);
        if (isScorm > 0)
        {
            HtmlGenericControl totalLessonsSpan = e.Item.FindControl("totalLessonsSpan") as HtmlGenericControl;
            totalLessonsSpan.Text = "100";
        }
    }
}

You probably don't want to loop through the data and swap it there, then bind when you can do it during the bind.

Alternately, something I hate that DB's do because of my need for data integrity, is change it in your SQL select with case statements.

hunter 2009-02-24 20:49:10

Answer 2

+1 A:

Does adding rptBundles.DataBind() after setting DataSource fix the problem?

Also, you might want to check out the DataTable.Select method to only select (and then modify) rows where isScorm = 1.

Si 2009-02-24 21:09:55

ansaurus

tags:

views:

answers:

How would I search through a DataSet and change data in it before it gets bound?

related questions