I have the following code:
[<asp:GridView ID="GridView1" runat="server" HorizontalAlign="Center"
AutoGenerateColumns="False" DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField DataField="SchedName" HeaderText="SchedName"
SortExpression="SchedName" />
<asp:BoundField DataField="ActivityDate" HeaderText="ActivityDate"
ReadOnly="True" SortExpression="ActivityDate" />
<asp:BoundField DataField="By" HeaderText="By" SortExpression="By" />
<asp:BoundField DataField="Activity" HeaderText="Activity" ReadOnly="True"
SortExpression="Activity" />
<asp:BoundField DataField="FirstListing" HeaderText="FirstListing"
SortExpression="FirstListing" />
<asp:HyperLinkField DataTextField="OnCallStart" HeaderText="OncallStart" DataNavigateUrlFields="SchedName,OncallStart"
DataNavigateUrlFormatString="\website1\Default2.aspx?date={0:d}&schedule={1}"
SortExpression="OnCallStart" NavigateUrl="\website1\default2.aspx" />
<asp:BoundField DataField="OnCallEnd" HeaderText="OnCallEnd" ReadOnly="True"
SortExpression="OnCallEnd" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:MDRConnectionString %>"
SelectCommand="sp_getoncallresults2" SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:ControlParameter ControlID="sincedateTextBox" DbType="DateTime"
Name="sincedate" PropertyName="Text" />
<asp:ControlParameter ControlID="schednameTextBox" Name="schedname"
PropertyName="Text" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
and what I'm trying to do is to pass the values of the hyperlink field to default2.aspx, which will then sends the variable of "date" and "schedname" to a stored SQL procedure. The problem is that the link for the hyperlink field doesn't show up in the field so users can't click on it to take them to the second page and my the stored procedure isn't firing on the second page. I don't know what I'm missing in the above code that's not allowing this to work. Can someone please assist?
Thank you
Doug