Connecting Tech Pros Worldwide Forums | Help | Site Map

Accessing data in multiple tables within a dataset

Moojjoo
Guest
 
Posts: n/a
#1: Nov 17 '05
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?



Nicholas Paldino [.NET/C# MVP]
Guest
 
Posts: n/a
#2: Nov 17 '05

re: Accessing data in multiple tables within a dataset


Moojjoo,

I'm not sure, but isn't the container accessing the parent, and not the
child? You would need to use the data relation binding to the child and
then access the field through there.

Hope this helps.


--
- Nicholas Paldino [.NET/C# MVP]
- mvp@spam.guard.caspershouse.com

"Moojjoo" <Moojjoo@discussions.microsoft.com> wrote in message
news:BAABFB17-ED0D-4272-825E-EC6D09B13568@microsoft.com...[color=blue]
> 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?
>
>[/color]


Closed Thread


Similar C# / C Sharp bytes