Unexplained error when databinding

[Nathan Sokalski]

I am using a DataSet as the DataSource of a DataList in my code. The SQL
used to get the data from the database begins with:
SELECT
members.organiz ation,artists.a rtist,artists.e mail,artists.we bsite,members.e mail
FROM members INNER JOIN artists ON members.memberi d=artists.membe rid WHERE
Notice that both tables involved in the SELECT statement have a field named
email. First, I do not know how to specify which one I want in my
databinding expressions (I tried DataItem.artist s.email and
DataItem.member s.email, but that gave me an error too). Second, I know that
my DataSet is getting filled correctly because my first databinding
expression worked (see line 71 in the error). My error is as follows:
Server Error in '/' Application.
--------------------------------------------------------------------------------

DataBinder.Eval : 'System.Data.Da taRowView' does not contain a property with
the name email.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Web.Http Exception: DataBinder.Eval :
'System.Data.Da taRowView' does not contain a property with the name email.

Source Error:

Line 70: <ItemTemplate >
Line 71: <asp:Label id=lblOrganizat ion1 runat="server" Width="175px"
text='<%# DataBinder.Eval (Container, "DataItem.organ ization")
%>'></asp:Label>
Line 72: <asp:HyperLin k id="lnkPresente rEmail1" runat="server"
Width="175px" text='<%# DataBinder.Eval (Container, "DataItem.email ") %>'
NavigateUrl='<% # DataBinder.Eval (Container, "DataItem.email ","MAILTO:{ 0}")
%>' Target="_blank" ></asp:HyperLink>
Line 73: <asp:Label id=lblArtist1 runat="server" Width="125" text='<%#
DataBinder.Eval (Container, "DataItem.artis t") %>'></asp:Label>
Line 74: <asp:HyperLin k id=lnkEmail1 runat="server" Width="175"
text='<%# DataBinder.Eval (Container, "DataItem.email ") %>' NavigateUrl='<% #
DataBinder.Eval (Container, "DataItem.email ","MAILTO:{ 0}") %>'
Target="_blank" ></asp:HyperLink>

Source File: D:\Clients\1265 4\papresenters. org\papresenter s.org\search.as px
Line: 72

Stack Trace:

[HttpException (0x80004005): DataBinder.Eval : 'System.Data.Da taRowView' does
not contain a property with the name email.]
System.Web.UI.D ataBinder.GetPr opertyValue(Obj ect container, String
propName) +146
System.Web.UI.D ataBinder.Eval( Object container, String[] expressionParts )
+71
System.Web.UI.D ataBinder.Eval( Object container, String expression) +82
ASP.search_aspx .__DataBind__co ntrol34(Object sender, EventArgs e) in
D:\Clients\1265 4\papresenters. org\papresenter s.org\search.as px:72
System.Web.UI.C ontrol.OnDataBi nding(EventArgs e) +66
System.Web.UI.C ontrol.DataBind () +26
System.Web.UI.C ontrol.DataBind () +86
System.Web.UI.W ebControls.Data List.CreateItem (Int32 itemIndex,
ListItemType itemType, Boolean dataBind, Object dataItem) +127
System.Web.UI.W ebControls.Data List.CreateCont rolHierarchy(Bo olean
useDataSource) +683
System.Web.UI.W ebControls.Base DataList.OnData Binding(EventAr gs e) +48
System.Web.UI.W ebControls.Base DataList.DataBi nd() +23
PAPresenters.se arch.btnSearch_ Click(Object sender, EventArgs e)
System.Web.UI.W ebControls.Butt on.OnClick(Even tArgs e) +108
System.Web.UI.W ebControls.Butt on.System.Web.U I.IPostBackEven tHandler.RaiseP ostBackEvent(St ring
eventArgument) +57
System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandler
sourceControl, String eventArgument) +18
System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection postData) +33
System.Web.UI.P age.ProcessRequ estMain() +1292

--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.432 2.2300; ASP.NET
Version:1.1.432 2.2300

Can anyone help me with this? Thanks.
--
Nathan Sokalski
nj********@hotm ail.com
http://www.nathansokalski.com/

[ng]

The reason you aren't finding 'email' is because SQL databases assign an
arbitrary column name if you have two matching names, or they leave the
qualifier in the name, such as artists.email and members.email. Try
assigning new names to the columns in your SQL statement, like "select
members.email m_email, artists.email a_email" and then use the new
column names in your binding.

Tom
Nathan Sokalski wrote:

I am using a DataSet as the DataSource of a DataList in my code. The SQL
used to get the data from the database begins with:
SELECT
members.organi zation,artists. artist,artists. email,artists.w ebsite,members. email
FROM members INNER JOIN artists ON members.memberi d=artists.membe rid WHERE
Notice that both tables involved in the SELECT statement have a field named
email. First, I do not know how to specify which one I want in my
databinding expressions (I tried DataItem.artist s.email and
DataItem.membe rs.email, but that gave me an error too). Second, I know that
my DataSet is getting filled correctly because my first databinding
expression worked (see line 71 in the error). My error is as follows:
Server Error in '/' Application.
--------------------------------------------------------------------------------

DataBinder.Eva l: 'System.Data.Da taRowView' does not contain a property with
the name email.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Web.Http Exception: DataBinder.Eval :
'System.Data.D ataRowView' does not contain a property with the name email.

Source Error:

Line 70: <ItemTemplate >
Line 71: <asp:Label id=lblOrganizat ion1 runat="server" Width="175px"
text='<%# DataBinder.Eval (Container, "DataItem.organ ization")
%>'></asp:Label>
Line 72: <asp:HyperLin k id="lnkPresente rEmail1" runat="server"
Width="175px " text='<%# DataBinder.Eval (Container, "DataItem.email ") %>'
NavigateUrl='< %# DataBinder.Eval (Container, "DataItem.email ","MAILTO:{ 0}")
%>' Target="_blank" ></asp:HyperLink>
Line 73: <asp:Label id=lblArtist1 runat="server" Width="125" text='<%#
DataBinder.Eva l(Container, "DataItem.artis t") %>'></asp:Label>
Line 74: <asp:HyperLin k id=lnkEmail1 runat="server" Width="175"
text='<%# DataBinder.Eval (Container, "DataItem.email ") %>' NavigateUrl='<% #
DataBinder.Eva l(Container, "DataItem.email ","MAILTO:{ 0}") %>'
Target="_blank "></asp:HyperLink>

Source File: D:\Clients\1265 4\papresenters. org\papresenter s.org\search.as px
Line: 72

Stack Trace:

[HttpException (0x80004005): DataBinder.Eval : 'System.Data.Da taRowView' does
not contain a property with the name email.]
System.Web.UI.D ataBinder.GetPr opertyValue(Obj ect container, String
propName) +146
System.Web.UI.D ataBinder.Eval( Object container, String[] expressionParts )
+71
System.Web.UI.D ataBinder.Eval( Object container, String expression) +82
ASP.search_aspx .__DataBind__co ntrol34(Object sender, EventArgs e) in
D:\Clients\126 54\papresenters .org\papresente rs.org\search.a spx:72
System.Web.UI.C ontrol.OnDataBi nding(EventArgs e) +66
System.Web.UI.C ontrol.DataBind () +26
System.Web.UI.C ontrol.DataBind () +86
System.Web.UI.W ebControls.Data List.CreateItem (Int32 itemIndex,
ListItemType itemType, Boolean dataBind, Object dataItem) +127
System.Web.UI.W ebControls.Data List.CreateCont rolHierarchy(Bo olean
useDataSourc e) +683
System.Web.UI.W ebControls.Base DataList.OnData Binding(EventAr gs e) +48
System.Web.UI.W ebControls.Base DataList.DataBi nd() +23
PAPresenters.se arch.btnSearch_ Click(Object sender, EventArgs e)
System.Web.UI.W ebControls.Butt on.OnClick(Even tArgs e) +108
System.Web.UI.W ebControls.Butt on.System.Web.U I.IPostBackEven tHandler.RaiseP ostBackEvent(St ring
eventArgumen t) +57
System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandler
sourceContro l, String eventArgument) +18
System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection postData) +33
System.Web.UI.P age.ProcessRequ estMain() +1292

--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.432 2.2300; ASP.NET
Version:1.1.43 22.2300

Can anyone help me with this? Thanks.

[Bob]

Nathan:

Or you could just rename the fields in the database to MEmail and AEmail

Bob

[Bob]

Nathan:

Or you could rename the fields in the database tables to MEmail and AEmail.

Dont forget to clean up the garbage code left behind in the "Windows Form
Designer Generated Code.

Seems to be a problem with VS not doing it when you regenerate the DA's

Today I cleaned up some 2000 lines of code in there. Big diff in
performance.

Bob

"Nathan Sokalski" <nj********@hot mail.com> wrote in message
news:O7******** *****@TK2MSFTNG P10.phx.gbl...

I am using a DataSet as the DataSource of a DataList in my code. The SQL
used to get the data from the database begins with:
SELECT
members.organiz ation,artists.a rtist,artists.e mail,artists.we bsite,members.e mail
FROM members INNER JOIN artists ON members.memberi d=artists.membe rid WHERE
Notice that both tables involved in the SELECT statement have a field
named email. First, I do not know how to specify which one I want in my
databinding expressions (I tried DataItem.artist s.email and
DataItem.member s.email, but that gave me an error too). Second, I know
that my DataSet is getting filled correctly because my first databinding
expression worked (see line 71 in the error). My error is as follows:
Server Error in '/' Application.
--------------------------------------------------------------------------------

DataBinder.Eval : 'System.Data.Da taRowView' does not contain a property
with the name email.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Web.Http Exception: DataBinder.Eval :
'System.Data.Da taRowView' does not contain a property with the name email.

Source Error:

Line 70: <ItemTemplate >
Line 71: <asp:Label id=lblOrganizat ion1 runat="server" Width="175px"
text='<%# DataBinder.Eval (Container, "DataItem.organ ization")
%>'></asp:Label>
Line 72: <asp:HyperLin k id="lnkPresente rEmail1" runat="server"
Width="175px" text='<%# DataBinder.Eval (Container, "DataItem.email ") %>'
NavigateUrl='<% # DataBinder.Eval (Container, "DataItem.email ","MAILTO:{ 0}")
%>' Target="_blank" ></asp:HyperLink>
Line 73: <asp:Label id=lblArtist1 runat="server" Width="125" text='<%#
DataBinder.Eval (Container, "DataItem.artis t") %>'></asp:Label>
Line 74: <asp:HyperLin k id=lnkEmail1 runat="server" Width="175" text='<%#
DataBinder.Eval (Container, "DataItem.email ") %>' NavigateUrl='<% #
DataBinder.Eval (Container, "DataItem.email ","MAILTO:{ 0}") %>'
Target="_blank" ></asp:HyperLink>

Source File:
D:\Clients\1265 4\papresenters. org\papresenter s.org\search.as px Line: 72

Stack Trace:

[HttpException (0x80004005): DataBinder.Eval : 'System.Data.Da taRowView'
does not contain a property with the name email.]
System.Web.UI.D ataBinder.GetPr opertyValue(Obj ect container, String
propName) +146
System.Web.UI.D ataBinder.Eval( Object container, String[]
expressionParts ) +71
System.Web.UI.D ataBinder.Eval( Object container, String expression) +82
ASP.search_aspx .__DataBind__co ntrol34(Object sender, EventArgs e) in
D:\Clients\1265 4\papresenters. org\papresenter s.org\search.as px:72
System.Web.UI.C ontrol.OnDataBi nding(EventArgs e) +66
System.Web.UI.C ontrol.DataBind () +26
System.Web.UI.C ontrol.DataBind () +86
System.Web.UI.W ebControls.Data List.CreateItem (Int32 itemIndex,
ListItemType itemType, Boolean dataBind, Object dataItem) +127
System.Web.UI.W ebControls.Data List.CreateCont rolHierarchy(Bo olean
useDataSource) +683
System.Web.UI.W ebControls.Base DataList.OnData Binding(EventAr gs e) +48
System.Web.UI.W ebControls.Base DataList.DataBi nd() +23
PAPresenters.se arch.btnSearch_ Click(Object sender, EventArgs e)
System.Web.UI.W ebControls.Butt on.OnClick(Even tArgs e) +108

System.Web.UI.W ebControls.Butt on.System.Web.U I.IPostBackEven tHandler.RaiseP ostBackEvent(St ring
eventArgument) +57
System.Web.UI.P age.RaisePostBa ckEvent(IPostBa ckEventHandler
sourceControl, String eventArgument) +18
System.Web.UI.P age.RaisePostBa ckEvent(NameVal ueCollection postData) +33
System.Web.UI.P age.ProcessRequ estMain() +1292

--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.432 2.2300;
ASP.NET Version:1.1.432 2.2300

Can anyone help me with this? Thanks.
--
Nathan Sokalski
nj********@hotm ail.com
http://www.nathansokalski.com/

[Cor Ligthert [MVP]]

>

Or you could just rename the fields in the database to MEmail and AEmail

That is something I never would do. The method of ng is in my opinion the
right one.

Just my thought,

Cor

[Bob]

Cor:

Why not? Wouldn't it make things a little easyer to inerpret and provide
for less aliases?

Bob

[John Horst]

Nathan:

Change this:

SELECT
members.organiz ation,artists.a rtist,artists.e mail,artists.we bsite,member
s.email
FROM members INNER JOIN artists ON members.memberi d=artists.membe rid

to this:

SELECT m.organization, a.artist, a.email As AEmail,
a.website, m.email As MEmail
FROM members m
INNER JOIN artists a
ON m.memberid = a.memberid

This is called aliasing the tables and the columns that have the same
name (notice that I put an "m" after members and an "a" after artists;
these are the aliases for the tables). Your datatable (in the dataset)
will use the aliased named (Aemail and Memail). This way you can leave
your database as is.

John