ScottForgot

NEED: .NET multi-table master-detail type customizable forms and datagrid generator or at least easy-to-follow idiot-proof instruction. ASPMaker.net ain't got it. ASPRunner.net ain't got it. Those tools are great for quick easy creation of add, display, edit, copy, delete, search database connectivity and functionality but for only one table!! I need to do all these quickly using data from three Oracle database tables (will also need to consider furture use for MS Access tables). Any intelligent leads appreciated. My database is small with only about two dozen total fields and only two master-detail relationships - not that big of a deal, it would seem. But my search has turned up nothing usable so far. Grateful for any and all good ideas. Programmers, freelancers, all responders/responses welcome. I just need to get it done in a hurry!!! Thanks all!! Scott

bri189a, Thanks much for your response! I slight variation on your suggestion got me there!!

All, In the code below, I display a Name in the left column next to the right column where the doc type in the right column is Typ1. But my real need is to display the name (DataItem.Name) only for the first row and not because it corresponds with doc type Typ1. I've begun to learn a little bit about DataGridItems but need to figure out how to display field values conditioned upon being in a specific row, as in this case, the first row only. Can anyone show me how that would look? I will also need to know how to display the name (DataItem.Name) in place of "Search Results" between my HTML header tags. how can this be accomplished? Thanks all!! = = = = = <h2>Search Results</h2> <form id="Form1" method="post" runat="server" Font-Name="Verdana"> <asp:DataGrid id="dgDoc" runat="server" Autogeneratecolumns=false AllowPaging="True" PageSize="20" PagerStyle-Mode="NumericPages" PagerStyle-HorizontalAlign="Right" OnPageIndexChanged="dgDoc_Page" BorderColor="black" BorderWidth="1" GridLines="Both" CellPadding="3" CellSpacing="0" Font-Name="Verdana" Font-Size="8pt" HeaderStyle-BackColor="#aaaadd" AlternatingItemStyle-BackColor="#eeeeee"> <columns> <asp:TemplateColumn HeaderText="Name"> <ItemTemplate> <asp:Label runat="server" Text='<%# iif(DataBinder.Eval(Container.DataItem, "String03")="Typ1",DataBinder.Eval(Container, "DataItem.Name"),"") %>'> </asp:Label> </ItemTemplate> </asp:TemplateColumn> <asp:TemplateColumn HeaderText="Document"> <ItemTemplate> <asp:HyperLink runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "String03") %>' NavigateUrl= '<%# "showDocImages.aspx?NAME=" + DataBinder.Eval(Container, "DataItem.Name") + "&NODE_ID=" + DataBinder.Eval(Container, "DataItem.Node_ID").ToString() + "&SEARCH=" + SESSION("SEARCH") %>' > </asp:HyperLink> </ItemTemplate> </asp:TemplateColumn> <asp:boundcolumn headertext="Name" datafield="Name" visible="false" /> </columns> </asp:DataGrid> <p> <asp:LinkButton id="btnPrev" runat="server" Text="Previous page" CommandArgument="prev" ForeColor="navy" Font-Name="verdana" Font-size="8pt" OnClick="PagerButtonClick" /> <asp:LinkButton id="btnNext" runat="server" Text="Next page" CommandArgument="next" ForeColor="navy" Font-Name="verdana" Font-size="8pt" OnClick="PagerButtonClick" /> <p> <asp:Label id="feedbackLabel" runat="server" BackColor="Wheat" Font-Bold="True" Text="" /> </p> </form>