Here is a simple grid view page I made. [url]http://visualboxscore.com/boxscores/cfb_box_scores.aspx[/url]Ultimately I want to be able to filter every field that is listed. However, for now I am just learning this stuff and would like to just filter the by the name in the "offense" field.However, it is not binding the selection thus not filtering it out. Do you see any problems in my code?<%@ Page Language="VB" %><html> <head id="Head1" runat="server"> <title>GridView DetailsView Master-Details (2 Page)</title> </head> <body> <form id="form1" runat="server"> <b>Choose a team:</b> <asp:DropDownList ID="DropDownList1" DataSourceID="SqlDataSource2" AutoPostBack="true" DataTextField="offense" Runat="server" /> <asp:SqlDataSource ID="SqlDataSource2" Runat="server" SelectCommand="SELECT DISTINCT [offense] FROM [cfb_boxscores]" ConnectionString="<%$ ConnectionStrings:ConnectionString1 %>" /> <br /> <br /> <asp:GridView ID="GridView1" AllowSorting="True" AllowPaging="false" Runat="server" DataSourceID="SqlDataSource1" DataKeyNames="offense" AutoGenerateColumns="False"> <Columns> <asp:BoundField HeaderText="Date" DataField="date" DataFormatString="{0:MM/dd/yy}" ItemStyle-HorizontalAlign="Center" SortExpression="date" /> <asp:BoundField HeaderText="Offense" DataField="offense" ItemStyle-HorizontalAlign="Center" SortExpression="offense" /> <asp:BoundField HeaderText="Defense" DataField="defense" ItemStyle-HorizontalAlign="Center" SortExpression="defense" /> <asp:BoundField HeaderText="Rush Yards" DataField="rush_net" ItemStyle-HorizontalAlign="Center" SortExpression="rush_net" /> <asp:BoundField HeaderText="YPC" DataField="yards_per_carry" DataFormatString="{0:#.##}" ItemStyle-HorizontalAlign="Center" SortExpression="yards_per_carry" /> <asp:BoundField HeaderText="Pass Yards" DataField="pass_yards" ItemStyle-HorizontalAlign="Center" SortExpression="pass_yards" /> <asp:BoundField HeaderText="YPA" DataField="yards_per_att" ItemStyle-HorizontalAlign="Center" SortExpression="yards_per_att" /> <asp:BoundField HeaderText="Total Yards" DataField="total_yards" ItemStyle-HorizontalAlign="Center" SortExpression="total_yards" /> <asp:BoundField HeaderText="YPP" DataField="yards_per_play" ItemStyle-HorizontalAlign="Center" SortExpression="yards_per_play" /> <asp:BoundField HeaderText="Points" DataField="points" ItemStyle-HorizontalAlign="Center" SortExpression="points" /> </Columns> </asp:GridView> <asp:SqlDataSource ID="SqlDataSource1" Runat="server" SelectCommand="SELECT [date], [offense], [defense], [rush_net], [yards_per_carry], [pass_yards], [yards_per_att], [total_yards], [yards_per_play], [points] FROM [cfb_boxscores]" ConnectionString="<%$ ConnectionStrings:ConnectionString1 %>"> <SelectParameters> <asp:ControlParameter Name="Offense" ControlID="DropDownList1" /> </SelectParameters> </asp:SqlDataSource> </form> </body></html>overall I want to format the table look and and background but for now I just want to see how this stuff functions. Thanks!!
[RESOLVED] Trying to filter some data on SQL
Posted - 2008-04-14 : 20:40:03
