Good Monday Morning:

I am at a dead stop and I am hoping some other developers out there can help
me out. I have built a dataset that first contains a table populated from
SQL Server then I am adding another table that is built from the same Query
and data from active directory. I have built a parent/child relationship and
see all the data under my locals when debugging. Where I am having the
problem is displaying the data from the second table using data binding
expressions.

<%# DataBinder.Eval(Container.DataItem, "emp_file_path") %>

I keep getting the following error:

DataBinder.Eval: 'System.Data.DataRowView' does not contain a property with
the name emp_file_path.

I am a bit lost because that data does exsist in my dataset under the table
employeePhotos:

DataTable employeePhotos = ds.Tables.Add("Employee_Photos");
employeePhotos.Columns.Add("emp_photos_ID", typeof(Int32));
employeePhotos.Columns.Add("emp_LAN_ID", typeof(String));
employeePhotos.Columns.Add("emp_file_path", typeof(String));

I guess the true question is how do I access data in different tables using
data expressions?

Hi Moojjoo,

It seems you should use code like follows:

DataTable employeePhotos = new DataTable();
employeePhotos.Columns.Add("emp_photos_ID", typeof(Int32));
employeePhotos.Columns.Add("emp_LAN_ID", typeof(String));
employeePhotos.Columns.Add("emp_file_path", typeof(String));


// Fill data to employeePhotos

ds.Tables.Add(employeePhotos);

HTH

Elton Wang
(E-Mail Removed)





"Moojjoo" wrote:

> Good Monday Morning:
>
> I am at a dead stop and I am hoping some other developers out there can help
> me out. I have built a dataset that first contains a table populated from
> SQL Server then I am adding another table that is built from the same Query
> and data from active directory. I have built a parent/child relationship and
> see all the data under my locals when debugging. Where I am having the
> problem is displaying the data from the second table using data binding
> expressions.
>
> <%# DataBinder.Eval(Container.DataItem, "emp_file_path") %>
>
> I keep getting the following error:
>
> DataBinder.Eval: 'System.Data.DataRowView' does not contain a property with
> the name emp_file_path.
>
> I am a bit lost because that data does exsist in my dataset under the table
> employeePhotos:
>
> DataTable employeePhotos = ds.Tables.Add("Employee_Photos");
> employeePhotos.Columns.Add("emp_photos_ID", typeof(Int32));
> employeePhotos.Columns.Add("emp_LAN_ID", typeof(String));
> employeePhotos.Columns.Add("emp_file_path", typeof(String));
>
> I guess the true question is how do I access data in different tables using
> data expressions?
>