62,074
社区成员
发帖
与我相关
我的任务
分享
<script runat="server">
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
If (Session("ValidUser") <> "Admin") Then ClientScript.RegisterClientScriptBlock(Me.GetType, "Redirect", "<" & "script>parent.location='default.aspx';</" & "script>")
If Not Page.IsPostBack Then
LstAppCode_SelectedIndexChanged(sender, e)
End If
End Sub
Protected Sub LstAppCode_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs)
AccessDataSource1.SelectCommand = "Select * from [Brand] where AppCode='" & LstAppCode.SelectedValue & "'"
End Sub
Protected Sub LnkAdd_Click(ByVal sender As Object, ByVal e As System.EventArgs)
Server.Transfer("ht_AddBrand.aspx?AppCode=" & Server.UrlEncode(LstAppCode.SelectedValue))
End Sub
Protected Sub GridView1_RowEditing(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewEditEventArgs)
AccessDataSource1.SelectCommand = "Select * from [Brand] where AppCode='" & LstAppCode.SelectedValue & "'"
End Sub
Protected Sub GridView1_RowUpdated(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewUpdatedEventArgs)
AccessDataSource1.SelectCommand = "SELECT * FROM [Brand] Where AppCode='" & LstAppCode.SelectedValue & "'"
End Sub
Protected Sub GridView1_RowCancelingEdit(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCancelEditEventArgs)
AccessDataSource1.SelectCommand = "SELECT * FROM [Brand] Where AppCode='" & LstAppCode.SelectedValue & "'"
End Sub
</script>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server" style="font-size:14px;">
选择频道:<asp:DropDownList ID="LstAppCode" runat="server" OnSelectedIndexChanged="LstAppCode_SelectedIndexChanged" AutoPostBack="true" >
<asp:ListItem Value="FZ">云南服装</asp:ListItem>
<asp:ListItem Value="HZPZYX">云南化妆品专业线</asp:ListItem>
<asp:ListItem Value="PE">云南普洱茶</asp:ListItem>
<asp:ListItem Value="NY">云南内衣</asp:ListItem>
<asp:ListItem Value="XY">云南鞋业</asp:ListItem>
<asp:ListItem Value="HZPRH">云南化妆品(日化)</asp:ListItem>
</asp:DropDownList>
<asp:LinkButton ID="LnkAdd" runat="server" OnClick="LnkAdd_Click">新增品牌</asp:LinkButton>
<hr style="border-color:Lime; border-width:3px; border-style:ridge;" />
<div style="padding:10px 10px 10px 10px ">
<asp:GridView ID="GridView1" runat="server" DataSourceID="AccessDataSource1" AutoGenerateColumns="False"
DataKeyNames="BrandName,AppCode" AutoGenerateEditButton="true" OnRowEditing="GridView1_RowEditing" OnRowUpdated="GridView1_RowUpdated" OnRowCancelingEdit="GridView1_RowCancelingEdit" >
<Columns>
<asp:BoundField DataField="BrandName" HeaderText="名称" SortExpression="BrandName" />
<asp:BoundField DataField="AppCode" Visible="false" />
<asp:ImageField DataImageUrlField="LogoURL" HeaderText="图标" />
</Columns>
</asp:GridView>
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="/App_Data/heart.mdb"
UpdateCommand="update [Brand] set LogoURL=@LogoURL,BrandName=@BrandName where AppCode=@AppCode and BrandName=@BrandName">
<UpdateParameters>
<asp:ControlParameter ControlID="GridView1" Name="LogoURL" Type="String" />
<asp:ControlParameter ControlID="GridView1" Name="AppCode" Type="String" />
<asp:ControlParameter ControlID="GridView1" Name="BrandName" Type="String" />
</UpdateParameters>
</asp:AccessDataSource>
</div>
</form>
</body>
</html>