Figured out the problem - cutting/pasting code is not always your friend. Forgot to change the datalist name on the second control - it was still pointing to the first.
thanks anyway! --- In [email protected], "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 <*> 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/
