Let's see all your code. My guess is that you can control your
postback handling and get the results you want, it is very common to
have multiple controls with separate data sources on a single page.
On 6/1/05, kstrader2002 <[EMAIL PROTECTED]> wrote:
> I have 2 datalists and a datagrid on one page. I am using
> databinder.eval to retrieve the necessary values when the controls
> are bound to the database. Each of the controls requires a separate
> stored procedure to retrieve the correct data for the control - I am
> unable to combine them into a single stored procedure. The problem
> I am running into is that if for instance the first control displays
> name and total hours and the second control displays activity and
> hours - it causes an error on the first control because after
> evaluating the second control it will say that "name" does not exist
> in the dataview - which is being caused because it is rebinding the
> first datalist when it binds for the second datalist control. How
> do I get each control to only bind for the data they are targeted
> for?
>
> Here is the code for my 2 datalists - there is also a datagrid which
> I did not include:
> <P><asp:label id="lblDtList" runat="server" Font-
> Bold="True"></asp:label></P>
> <asp:datalist id="dlstUserHours" runat="server" Width="752px"
> RepeatColumns="2">
> <ItemStyle HorizontalAlign="Left" Width="450px"></ItemStyle>
> <ItemTemplate>
> <TABLE height="25">
> <TR>
> <TD width="20%"></TD>
> <TD width="50%"><%# Databinder.Eval(Container,"DataItem.Name") ></TD>
> <TD width="10%"> <%# Databinder.Eval
> (Container,"DataItem.SuppAct_Hours") %></TD>
> <TD width="20%"></TD>
> </TR>
> </TABLE>
> </ItemTemplate>
> </asp:datalist></TD>
> <TD height="115"></TD>
> </TR>
> <tr>
> <TD vAlign="top" width="70%" height="115">
> <P><asp:label id="lblDtListActivity" runat="server" Font-
> Bold="True"></asp:label></P>
> <asp:datalist id="dlstActivity" runat="server" Width="752px">
> <ItemStyle HorizontalAlign="Left" Width="450px"></ItemStyle>
> <ItemTemplate>
> <TABLE height="25">
> <TR>
> <TD width="20%"></TD>
> <TD width="50%"><%#
> Databinder.EvalContainer,"DataItem.ActivityName") %></TD>
> <TD width="10%"> <%# Databinder.Eval
> (Container,"DataItem.suppAct_hours") %></TD>
> <TD width="20%"></TD>
> </TR>
> </TABLE>
> </ItemTemplate>
> </asp:datalist></TD>
> <TD height="115"></TD>
> </tr>
> <TR>
>
> Here is the corresponding databinding routines:
> Sub Getdldata()
> 'Dim locID As Integer = Request.QueryString("LID")
> 'Dim iloc As Integer = Convert.ToInt32(locID)
> Try
> Dim dtUserHours = DataHelper.GetUserHours()
> Dim dvw_userHours = New DataView(dtUserHours)
> dvw_userHours.RowFilter = "LocationID=" & locID & " and
> per_inactiveID =0"
> Dim r As DataRowView
> BindDlst(dvw_userHours)
> Catch ex As Exception
> Throw New Exception("Get User hours failed", ex)
> End Try
>
> End Sub
>
> Sub GetdlActivitydata()
> Try
> Dim dtLocActivity = DataHelper.GetAllActivitiesAndUsers
> Dim dvw_LocActivity = New DataView(dtLocActivity)
> dvw_LocActivity.RowFilter = "Act_SubCategoryID = 24"
> BindActivityDlst(dvw_LocActivity)
> Catch ex As Exception
> Throw New Exception("Get People Activity List failed",
> ex)
> End Try
>
> End Sub
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
--
Dean Fiala
Very Practical Software, Inc
http://www.vpsw.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
