ASP.NET - Trying to use Radiobutton List and one gridview

Asked By Rosie Buchanan on 23-Feb-12 03:41 PM
I've added a radiobutton List and a gridview to the page:

<asp:RadioButtonList ID="Pending" runat="server" AutoPostBack="True" >
<asp:ListItem Value="300">Over 300</asp:ListItem>
<asp:ListItem Value="350">Over 350</asp:ListItem>
<asp:ListItem Value="400">Over 400</asp:ListItem>
</asp:RadioButtonList>
<br />

<br />

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource7" EnableModelValidation="True" Width="331px"
CaptionAlign="Top" Height="126px" BackColor="White" BorderColor="#DCBE68"
BorderStyle="Solid" BorderWidth="1px" CellPadding="4"
HorizontalAlign="Center" CellSpacing="2" Font-Names="Arial"
AllowSorting="True">
<Columns>
<asp:BoundField DataField="Doc" HeaderText="DDS" SortExpression="Doc" />
<asp:TemplateField HeaderText="Total Pending" SortExpression="cnt">
<ItemTemplate>
<asp:HyperLink ID="HyperLink1" runat="server"
NavigateUrl='<%# "PendingDDS.aspx?doc=" & Eval("doc") %>'
Text='<%# Eval("cnt") %>'></asp:HyperLink>
</ItemTemplate>

<HeaderStyle Wrap="False" />
</asp:TemplateField>
</Columns>
</asp:GridView>

When the page loads it shows one data.  I want to be able to click on the listitem 300 and have the same gridview load with new data.

I added this to the code behind:

Protected Sub Pending_SelectedIndexChanged(ByVal sender As Object, ByVal e As EventArgs) Handles Pending.SelectedIndexChanged

Dim conn As New Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings("PendingConnectionString").ConnectionString)

Dim cmd As New Data.SqlClient.SqlCommand
Dim cmdPending As New Data.SqlClient.SqlCommand

With cmdPending
.CommandType = Data.CommandType.StoredProcedure

.CommandText = "Get301"
.Connection = conn



If Pending.SelectedItem.Value = "300" And Request.QueryString = "F03" Then
.Parameters.AddWithValue("@doc", Pending.SelectedValue)
End If

End With

Dim adapter As New Data.SqlClient.SqlDataAdapter(cmdPending)

Try

conn.Open()

Dim ds As New Data.DataSet
adapter.Fill(ds)



'GridView1.DataSource = ds

GridView1.DataBind()

Finally


conn.Dispose()

End Try

End Sub

I have the blue squiggly line under request.querystring ="F03"   (saying overload resolution failed) What am I doing wrong?

Here's the stored procedure:

if @doc = 'F03'
begin
SELECT
doc,
COUNT(*) AS cnt
FROM
(
Select
doc
FROM pendingdds p
join Offices.dbo.OfficeCodes d
on d.officecode = p.doc
where d.typecode='7' and d.reportsto='F03'
and ( Datediff(DAY, filedate, Getdate()) > 249 )
AND ( Datediff(DAY, filedate, Getdate()) < 301)
Group By
doc, clm, filedate
) AS T
GROUP BY
doc
end

What am I doing wrong or is the the right way to do it?
D Company replied to Rosie Buchanan on 26-Feb-12 01:21 AM
it shows that u might be trying to wrong parameter to a function.or when u are requestion for query string u have to also check if it is not null. it should work after that

regards
D
Rosie Buchanan replied to D Company on 26-Feb-12 09:58 AM
Thanks I just used this:

.Parameters.AddWithValue("@doc", Pending.SelectedValue)  

But I didn't get anything.  How can I check for request.querystring"(FO")  I stepped through the application and I did get the right radio button in the Pending.SelectedValue.