请教高手,谁为我比较比较这两段代码
前面一段是我自己生成的,后面是从书的随机盘中拷过来的,我深得它们一模一样,但我的就是实现不了功能,为什么呀,第一次载入页面时显示全部记录,以后根据下拉列表筛选显示的记录
第一段代码:
<asp:DropDownList ID="DropDownList1" runat="server"
AutoPostBack="True"
DataSourceID="SqlDataSource2"
DataTextField="state"
DataValueField="state"
AppendDataBoundItems="True">
<Items>
<asp:ListItem Text="(Choose a state)" />
</Items>
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:LocalSqlPubs %>"
SelectCommand="SELECT DISTINCT [state] FROM [authors]">
</asp:SqlDataSource>
<br />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField DataField="au_id" HeaderText="au_id" ReadOnly="True" SortExpression="au_id" />
<asp:BoundField DataField="au_lname" HeaderText="au_lname" SortExpression="au_lname" />
<asp:BoundField DataField="au_fname" HeaderText="au_fname" SortExpression="au_fname" />
<asp:BoundField DataField="phone" HeaderText="phone" SortExpression="phone" />
<asp:BoundField DataField="address" HeaderText="address" SortExpression="address" />
<asp:BoundField DataField="city" HeaderText="city" SortExpression="city" />
<asp:BoundField DataField="state" HeaderText="state" SortExpression="state" />
<asp:BoundField DataField="zip" HeaderText="zip" SortExpression="zip" />
<asp:CheckBoxField DataField="contract" HeaderText="contract" SortExpression="contract" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:LocalSqlPubs %>"
CancelSelectOnNullParameter="False"
SelectCommand="
SELECT * FROM authors
WHERE state = IsNull(@state,state)"
>
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList1" Name="state" PropertyName="SelectedValue"
/>
</SelectParameters>
</asp:SqlDataSource>
第二段代码:
<asp:DropDownList ID="DropDownList1" Runat="server"
AppendDataBoundItems="true"
AutoPostBack="True"
DataSourceID="SqlDataSource2"
DataTextField="state"
DataValueField="state">
<Items>
<asp:ListItem Text="(Choose a state)" Value="" />
</Items>
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource2" Runat="server"
SelectCommand="SELECT DISTINCT [state] FROM [authors]"
ConnectionString="<%$ ConnectionStrings:LocalSqlPubs %>"/>
<br />
<br />
<asp:GridView ID="GridView1" Runat="server"
DataSourceID="SqlDataSource1"
AllowSorting="True"
AutoGenerateColumns="False"
AllowPaging="True">
<Columns>
<asp:BoundField HeaderText="au_id" DataField="au_id" SortExpression="au_id" />
<asp:BoundField HeaderText="au_lname" DataField="au_lname" SortExpression="au_lname" />
<asp:BoundField HeaderText="au_fname" DataField="au_fname" SortExpression="au_fname" />
<asp:BoundField HeaderText="phone" DataField="phone" SortExpression="phone" />
<asp:BoundField HeaderText="address" DataField="address" SortExpression="address" />
<asp:BoundField HeaderText="city" DataField="city" SortExpression="city" />
<asp:BoundField HeaderText="state" DataField="state" SortExpression="state" />
<asp:BoundField HeaderText="zip" DataField="zip" SortExpression="zip" />
<asp:CheckBoxField HeaderText="contract" SortExpression="contract" DataField="contract" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" Runat="server"
ConnectionString='<%$ ConnectionStrings:LocalSqlPubs %>'
CancelSelectOnNullParameter="false"
SelectCommand="
SELECT * FROM authors
WHERE state = IsNull(@state, state)">
<SelectParameters>
<asp:ControlParameter Name="state"
ControlID="DropDownList1"
PropertyName="SelectedValue" />
</SelectParameters>
</asp:SqlDataSource>