为什么GridView有的列能更新，有的列不能更新？

2009-06-20 08:32:49 99 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

GridView更新,编辑,删除 1.创建数据表USE NorthWindGO--创建人事表CREATE TABLE HmanHant( Empno varchar(9) primary key not null, EmpNM nvarchar(10) not null, IdentifyNO nvarchar(17) null, BirthYMD varchar(8) null, Oaddr nvarchar(50) nul 阅读详情

请看我的全部代码，现在出现的奇怪现象是，GridView1一共三列显，点＂编辑＂＂更新＂，同时修改BrandName（名称）一列，和LogoURL字段（图标）一列时，LogoURL是可以修改其值的，但是BrandName的值始终不会变，这个是怎么回事呢？

<%@ Page Language="VB" Trace="False" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<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>