|
Subject:
|
Master/Detail page
|
|
Posted By:
|
yteferi
|
Post Date:
|
4/5/2006 3:35:00 PM
|
I have created two pages one master and one detail page.I did pass a value using a query string to detail page. However, when I click the link field from the master page, the detail page comes up blank and it does not show me any error messge either.can some one look at the code below and let me know what is wrong with the code. I am using visual studio 2005 and oracle 9i db. thanks
Master page
***********************
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="master.aspx.vb" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<span style="font-weight: bold; color: #333366; font-style: italic; font-variant: normal">
Master-Detail Page 1:</span><br />
<br />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" BackColor="White"
BorderColor="#CC9966" BorderStyle="None" BorderWidth="1px" CellPadding="4" DataKeyNames="LCONTID"
DataSourceID="SqlDataSource1" Width="100%">
<FooterStyle BackColor="#FFFFCC" ForeColor="#330099" />
<Columns>
<asp:BoundField DataField="MIN(J.ROUTE)" HeaderText="T.H. Number" SortExpression="MIN(J.ROUTE)">
<ItemStyle Font-Size="Small" HorizontalAlign="Left" />
<HeaderStyle Font-Size="Small" HorizontalAlign="Left" />
</asp:BoundField>
<asp:BoundField DataField="LETTING" HeaderText="Letting Date" ReadOnly="True" SortExpression="LETTING">
<ItemStyle Font-Size="Small" HorizontalAlign="Left" />
<HeaderStyle Font-Size="Small" HorizontalAlign="Left" />
</asp:BoundField>
<asp:BoundField DataField="CALL" HeaderText="Call Number" ReadOnly="True" SortExpression="CALL">
<ItemStyle Font-Size="Small" HorizontalAlign="Left" />
<HeaderStyle Font-Size="Small" HorizontalAlign="Left" />
</asp:BoundField>
<asp:BoundField DataField="LCONTID" HeaderText="Contract Id" SortExpression="LCONTID">
<ItemStyle Font-Size="Small" HorizontalAlign="Left" />
<HeaderStyle Font-Size="Small" HorizontalAlign="Left" />
</asp:BoundField>
<asp:BoundField DataField="CPROJNUM" HeaderText="S.P. Number" SortExpression="CPROJNUM">
<ItemStyle Font-Size="Small" HorizontalAlign="Left" />
<HeaderStyle Font-Size="Small" HorizontalAlign="Left" />
</asp:BoundField>
<asp:BoundField DataField="CCNTY1" HeaderText="County Number" SortExpression="CCNTY1">
<ItemStyle Font-Size="Small" HorizontalAlign="Left" />
<HeaderStyle Font-Size="Small" HorizontalAlign="Left" />
</asp:BoundField>
<asp:BoundField DataField="CFACSSUP" HeaderText="District" SortExpression="CFACSSUP">
<ItemStyle Font-Size="Small" />
<HeaderStyle Font-Size="Small" HorizontalAlign="Left" />
</asp:BoundField>
<asp:HyperLinkField DataNavigateUrlFields="LCONTID" DataNavigateUrlFormatString="detail.aspx?lcontid={0}"
Text="Details..." HeaderText="Details" >
<ItemStyle Font-Size="Small" HorizontalAlign="Left" />
<HeaderStyle Font-Size="Small" HorizontalAlign="Left" />
</asp:HyperLinkField>
</Columns>
<RowStyle BackColor="White" ForeColor="#330099" />
<SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="#663399" />
<PagerStyle BackColor="#FFFFCC" ForeColor="#330099" HorizontalAlign="Center" />
<HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="#FFFFCC" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" SelectCommand="SELECT DISTINCT Min(J.ROUTE),L.LETTING, L.CALL,L.LCONTID,Q.CPROJNUM,Q.CFACSSUP,Q.CCNTY1 FROM VENDOR V, VENDADDR R, LETPROP L, PLANHOLD P,PROPOSAL Q, PROJECT J,PROPPROJ K WHERE V.VENDOR = R.VENDOR AND K.CONTID = Q.CONTID AND K.PCN = J.PCN AND L.LCONTID = K.CONTID AND P.VENDOR = V. VENDOR AND L.LETTING = P.LETTING AND P.LETTING = '06042801' AND L.CALL = P.CALL AND R.ADDRNUM = P.BILLTO group by V.VENDOR,R.ADDRNUM, V.VNAMEL, R.AADDR1,P.BILLTO,R.ACITY, R.ASTATE, R.AZIPCODE,R.VASST1,R.APHONE,L.LETTING, L.CALL,L.LCONTID,Q.CPROJNUM,Q.CFACSSUP,Q.CCNTY1">
</asp:SqlDataSource>
</div>
</form>
</body>
</html>
****************************
detail page:
*******************************
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="detail.aspx.vb" Inherits="detail" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<span style="font-weight: bold; color: #333366; font-style: italic; font-variant: normal">
Page 2..........<br />
Vendor List For Current Letting:<br />
Please work for me I am running out of patient if you do now work soon i might abandon
you please work for me......<br />
</span>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="LCONTID" DataSourceID="SqlDataSource2" CellPadding="4" ForeColor="#333333" GridLines="None" Width="100%">
<Columns>
<asp:BoundField DataField="LCONTID" HeaderText="Contract Id" SortExpression="LCONTID" />
<asp:BoundField DataField="LETTING" HeaderText="Letting Date" SortExpression="LETTING" />
<asp:BoundField DataField="RT" HeaderText="Route Number" SortExpression="RT" />
<asp:BoundField DataField="VENDOR" HeaderText="Vendor" SortExpression="VENDOR" />
<asp:BoundField DataField="ADDRNUM" HeaderText="Address" SortExpression="ADDRNUM" />
<asp:BoundField DataField="VNAMEL" HeaderText="Vendor Name" SortExpression="VNAMEL" />
<asp:BoundField DataField="AADDR1" HeaderText="Address 2" SortExpression="AADDR1" />
</Columns>
<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
<EditRowStyle BackColor="#999999" />
<SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
<PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" ForeColor="#284775" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" SelectCommand='SELECT DISTINCT "LCONTID", "LETTING", "RT", "VENDOR", "ADDRNUM", "VNAMEL", "AADDR1", "BILLTO" FROM "DETAILPHLFORBIDLET" WHERE ("LCONTID" = :LCONTID)'>
<SelectParameters>
<asp:QueryStringParameter Name="LCONTID" QueryStringField="LCONTID" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
</div>
</form>
</body>
</html>
|
|
Reply By:
|
MDM
|
Reply Date:
|
4/5/2006 4:06:33 PM
|
Not an expert by any chance,
but I do these things using details view form on the master - insert a hyperlink , specify the parameter i.e. requestid,eventid,whateva and specify the hyperlink in he following manner http//www.nextpage.aspx?userid(specify here the parameter)={0}. NO SPACES.
On the details page you can have a grid and catch the data based on the q.string parameter.
hope it helps
MDM
|
|
