ASP.NET 2.0快速入门(2)：ASP.NET 2.0 数据绑定的例子点击more info 都显示第一个数据
au_id au_lname au_fname city state zip details172-32-1176 White Johnson Menlo Park CA 94025 more info
213-46-8915 Green Marjorie Oakland CA 94618 more info
238-95-7766 Carson Cheryl Berkeley CA 94705 more info
267-41-2394 O'Leary Michael San Jose CA 95128 more info
274-80-9391 Straight Dean Oakland CA 94609 more info
409-56-7008 Bennet Abraham Berkeley CA 94705 more info
427-17-2319 Dull Ann Palo Alto CA 94301 more info
472-27-2349 Gringlesby Burt Covelo CA 95428 more info
486-29-1786 Locksley Charlene San Francisco CA 94130 more info
672-71-3249 Yokomoto Akiko Walnut Creek CA 94595 more info
724-08-9931 Stringer Dirk Oakland CA 94609 more info
724-80-9391 MacFeather Stearns Oakland CA 94612 more info
756-30-7391 Karsen Livia Oakland CA 94609 more info
846-92-7186 Hunter Sheryl Palo Alto CA 94301 more info
893-72-1158 McBadden Heather Vacaville CA 95688 more info
点击每个more info 时都显示第一列的数据 怎么改正显示相对应的数据
代码<%@ Page Language="VB" AutoEventWireup="false" CodeFile="gridview.aspx.vb" Inherits="gridview" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="CompareAllValues"
ConnectionString="<%$ ConnectionStrings:pubsConnectionString %>" DeleteCommand="DELETE FROM [authors] WHERE [au_id] = @original_au_id AND [au_lname] = @original_au_lname AND [au_fname] = @original_au_fname AND [phone] = @original_phone AND [address] = @original_address AND [city] = @original_city AND [state] = @original_state AND [zip] = @original_zip AND [contract] = @original_contract"
InsertCommand="INSERT INTO [authors] ([au_id], [au_lname], [au_fname], [phone], [address], [city], [state], [zip], [contract]) VALUES (@au_id, @au_lname, @au_fname, @phone, @address, @city, @state, @zip, @contract)"
SelectCommand="SELECT * FROM [authors] WHERE ([state] = @state)" UpdateCommand="UPDATE [authors] SET [au_lname] = @au_lname, [au_fname] = @au_fname, [phone] = @phone, [address] = @address, [city] = @city, [state] = @state, [zip] = @zip, [contract] = @contract WHERE [au_id] = @original_au_id AND [au_lname] = @original_au_lname AND [au_fname] = @original_au_fname AND [phone] = @original_phone AND [address] = @original_address AND [city] = @original_city AND [state] = @original_state AND [zip] = @original_zip AND [contract] = @original_contract">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList1" Name="state" PropertyName="SelectedValue"
Type="String" />
</SelectParameters>
<DeleteParameters>
<asp:Parameter Name="original_au_id" Type="String" />
<asp:Parameter Name="original_au_lname" Type="String" />
<asp:Parameter Name="original_au_fname" Type="String" />
<asp:Parameter Name="original_phone" Type="String" />
<asp:Parameter Name="original_address" Type="String" />
<asp:Parameter Name="original_city" Type="String" />
<asp:Parameter Name="original_state" Type="String" />
<asp:Parameter Name="original_zip" Type="String" />
<asp:Parameter Name="original_contract" Type="Boolean" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="au_lname" Type="String" />
<asp:Parameter Name="au_fname" Type="String" />
<asp:Parameter Name="phone" Type="String" />
<asp:Parameter Name="address" Type="String" />
<asp:Parameter Name="city" Type="String" />
<asp:Parameter Name="state" Type="String" />
<asp:Parameter Name="zip" Type="String" />
<asp:Parameter Name="contract" Type="Boolean" />
<asp:Parameter Name="original_au_id" Type="String" />
<asp:Parameter Name="original_au_lname" Type="String" />
<asp:Parameter Name="original_au_fname" Type="String" />
<asp:Parameter Name="original_phone" Type="String" />
<asp:Parameter Name="original_address" Type="String" />
<asp:Parameter Name="original_city" Type="String" />
<asp:Parameter Name="original_state" Type="String" />
<asp:Parameter Name="original_zip" Type="String" />
<asp:Parameter Name="original_contract" Type="Boolean" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="au_id" Type="String" />
<asp:Parameter Name="au_lname" Type="String" />
<asp:Parameter Name="au_fname" Type="String" />
<asp:Parameter Name="phone" Type="String" />
<asp:Parameter Name="address" Type="String" />
<asp:Parameter Name="city" Type="String" />
<asp:Parameter Name="state" Type="String" />
<asp:Parameter Name="zip" Type="String" />
<asp:Parameter Name="contract" Type="Boolean" />
</InsertParameters>
</asp:SqlDataSource>
<br />
state
<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" DataSourceID="SqlDataSource2"
DataTextField="state" DataValueField="state">
<asp:ListItem>CA</asp:ListItem>
<asp:ListItem>MN</asp:ListItem>
</asp:DropDownList><asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:pubsConnectionString %>"
SelectCommand="SELECT DISTINCT state FROM authors"></asp:SqlDataSource>
</div>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4"
DataKeyNames="au_id" DataSourceID="SqlDataSource1" ForeColor="#333333" GridLines="None">
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<RowStyle BackColor="#EFF3FB" />
<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="city" HeaderText="city" SortExpression="city" />
<asp:BoundField DataField="state" HeaderText="state" SortExpression="state" />
<asp:BoundField DataField="zip" HeaderText="zip" SortExpression="zip" />
<asp:HyperLinkField DataNavigateUrlFields="au_id" DataNavigateUrlFormatString="details.aspx?field={0}"
HeaderText="details" Text="more info" DataTextFormatString="go back to: {0}" />
</Columns>
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<EditRowStyle BackColor="#2461BF" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
</form>
</body>
</html>
--------------------编程问答-------------------- <%@ Page Language="VB" AutoEventWireup="false" CodeFile="details.aspx.vb" Inherits="details" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="CompareAllValues"
ConnectionString="<%$ ConnectionStrings:pubsConnectionString %>" DeleteCommand="DELETE FROM [authors] WHERE [au_id] = @original_au_id AND [au_lname] = @original_au_lname AND [au_fname] = @original_au_fname AND [phone] = @original_phone AND [address] = @original_address AND [city] = @original_city AND [state] = @original_state AND [zip] = @original_zip AND [contract] = @original_contract"
InsertCommand="INSERT INTO [authors] ([au_id], [au_lname], [au_fname], [phone], [address], [city], [state], [zip], [contract]) VALUES (@au_id, @au_lname, @au_fname, @phone, @address, @city, @state, @zip, @contract)"
SelectCommand="SELECT * FROM [authors]" UpdateCommand="UPDATE [authors] SET [au_lname] = @au_lname, [au_fname] = @au_fname, [phone] = @phone, [address] = @address, [city] = @city, [state] = @state, [zip] = @zip, [contract] = @contract WHERE [au_id] = @original_au_id AND [au_lname] = @original_au_lname AND [au_fname] = @original_au_fname AND [phone] = @original_phone AND [address] = @original_address AND [city] = @original_city AND [state] = @original_state AND [zip] = @original_zip AND [contract] = @original_contract">
<DeleteParameters>
<asp:Parameter Name="original_au_id" Type="String" />
<asp:Parameter Name="original_au_lname" Type="String" />
<asp:Parameter Name="original_au_fname" Type="String" />
<asp:Parameter Name="original_phone" Type="String" />
<asp:Parameter Name="original_address" Type="String" />
<asp:Parameter Name="original_city" Type="String" />
<asp:Parameter Name="original_state" Type="String" />
<asp:Parameter Name="original_zip" Type="String" />
<asp:Parameter Name="original_contract" Type="Boolean" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="au_lname" Type="String" />
<asp:Parameter Name="au_fname" Type="String" />
<asp:Parameter Name="phone" Type="String" />
<asp:Parameter Name="address" Type="String" />
<asp:Parameter Name="city" Type="String" />
<asp:Parameter Name="state" Type="String" />
<asp:Parameter Name="zip" Type="String" />
<asp:Parameter Name="contract" Type="Boolean" />
<asp:Parameter Name="original_au_id" Type="String" />
<asp:Parameter Name="original_au_lname" Type="String" />
<asp:Parameter Name="original_au_fname" Type="String" />
<asp:Parameter Name="original_phone" Type="String" />
<asp:Parameter Name="original_address" Type="String" />
<asp:Parameter Name="original_city" Type="String" />
<asp:Parameter Name="original_state" Type="String" />
<asp:Parameter Name="original_zip" Type="String" />
<asp:Parameter Name="original_contract" Type="Boolean" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="au_id" Type="String" />
<asp:Parameter Name="au_lname" Type="String" />
<asp:Parameter Name="au_fname" Type="String" />
<asp:Parameter Name="phone" Type="String" />
<asp:Parameter Name="address" Type="String" />
<asp:Parameter Name="city" Type="String" />
<asp:Parameter Name="state" Type="String" />
<asp:Parameter Name="zip" Type="String" />
<asp:Parameter Name="contract" Type="Boolean" />
</InsertParameters>
</asp:SqlDataSource>
</div>
<asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" DataKeyNames="au_id"
DataSourceID="SqlDataSource1" Height="50px" Width="125px">
<Fields>
<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" />
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" ShowInsertButton="True" />
</Fields>
</asp:DetailsView>
<asp:LinkButton ID="LinkButton1" runat="server" PostBackUrl="~/gridview.aspx">back</asp:LinkButton>
</form>
</body>
</html>
补充：.NET技术 , ASP.NET
