Hi,

Is it possible to add a custom row to a dataview? Here is an example of what I'm trying to do. A dataset is returned from a SQL query with two columns, ID and Name. I want to add a third column at runtime, for example Age. This data comes from somewhere else, say XML or some other datastore.

I am writing this out to DataList using the DataBinder.Eval method. How can I bind this external data to this datalist for each item? Is there another way to use DataBinder.Eval to set data from some other datasource that the one binded to the datalist? Can I add a row to the dataset's results before I pass it to the DataView?

-- shawn

Are you asking about adding a row or a column?

You can add a column to a datatable after you have retrieved it.
DataTable.Columns.Add(...)

Thanks, that was the trick - adding the column to the row in the DataTable, not the dataview or the dataset :)

What I am trying to do is calculate someones age based on 3 database columns of the int type, their birth day, month, and year. Here is my current calculation:

            // Fill Dataset
            sqlCmd.Fill(ds, "Member");

            // DataTable is created here
            DataTable dt = ds.Tables[0];

            // Add an "Age" column
            dt.Columns.Add("HowOld");

            // Calculate their age
            for (int i=0; i<dt.Rows.Count; i++)
            {
                dt.Rows[i]["HowOld"] = DateTime.Now.Year - (int)dt.Rows[i]["bday_year"];
            }


This doesn't take in account their birthday day being present in the current year though. Any idea how to accomindate that?

Thanks,

-- shawn

Hey,

You need to take into account the month and day that a person was born. If you store the whoe date as a DateTime field, DateTime has a .ToShortDateString() value which returns the date in 1/1/2000 format. Then you could parse it apart via .ToShortDateString().Split("/"c). If the month and day (for the bday) is after the current month and day, then it hasn't occurred yet and subtract one from the entire calculation for how old. Otherwise, if the month and day is on or before the current month/day, then don't subtract one, as their birthday has past.

Hope this helps,

Brian