formview根据有没有填写密码来更新

2011-08-18 12:04:50 160 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

基于Python和Django的学科竞赛管理系统设计与实现指南毕业设计是计算机专业学生综合运用所学知识的关键环节，而基于Python的Web开发项目因其开发效率与生态成熟度备受青睐。Django作为Python生态中最完整的重量级框架，内置ORM、Admin后台、认证体系等组件，为构建数据密集型管理系统提供了高效、安全的解决方案。本文从Django的核心原理出发，梳理其在权限控制、数据库建模、状态流转与并发处理上的技术优势，并结合高校学科竞赛管理的真实业务场景，阐述如何将竞赛发布、报名审核、成绩统计等流程系统化落地。无论您是正在规划毕业设计选题，还是希望深入了解Web 阅读详情

目的:如果填写了密码则对密码进行MD5加密后更新,如果没有填写密码则保留原来的密码,不更新
请教怎么写后台代码?

前端代码如下:



<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Formview2.aspx.cs" Inherits="DataBindControlsTest_Formview2" %>



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



<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

    <title></title>

</head>

<body>

    <form id="form1" runat="server">

    <div>

    

        <asp:FormView ID="FormView1" runat="server" DataKeyNames="loginName" 

            DataSourceID="SqlDataSource1">

            <EditItemTemplate>

                loginName:

                <asp:Label ID="loginNameLabel1" runat="server" 

                    Text='<%# Eval("loginName") %>' />

                <br />

                realname:

                <asp:TextBox ID="realnameTextBox" runat="server" 

                    Text='<%# Bind("realname") %>' />

                <br />

                password:

                <asp:TextBox ID="passwordTextBox" runat="server" Text='<%# Bind("password") %>' 

                    TextMode="Password" />

                <br />

                <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" 

                    CommandName="Update" Text="更新" />

                 <asp:LinkButton ID="UpdateCancelButton" runat="server" 

                    CausesValidation="False" CommandName="Cancel" Text="取消" />

            </EditItemTemplate>

            <InsertItemTemplate>

                loginName:

                <asp:TextBox ID="loginNameTextBox" runat="server" 

                    Text='<%# Bind("loginName") %>' />

                <br />

                realname:

                <asp:TextBox ID="realnameTextBox" runat="server" 

                    Text='<%# Bind("realname") %>' />

                <br />

                password:

                <asp:TextBox ID="passwordTextBox" runat="server" Text='<%# Bind("password") %>' 

                    TextMode="Password" />

                <br />

                <asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" 

                    CommandName="Insert" Text="插入" />

                 <asp:LinkButton ID="InsertCancelButton" runat="server" 

                    CausesValidation="False" CommandName="Cancel" Text="取消" />

            </InsertItemTemplate>

            <ItemTemplate>

                loginName:

                <asp:Label ID="loginNameLabel" runat="server" Text='<%# Eval("loginName") %>' />

                <br />

                realname:

                <asp:Label ID="realnameLabel" runat="server" Text='<%# Bind("realname") %>' />

                <br />

                password:

                <asp:Label ID="passwordLabel" runat="server" Text='<%# Bind("password") %>' />

                <br />

                <asp:LinkButton ID="EditButton" runat="server" CausesValidation="False" 

                    CommandName="Edit" Text="编辑" />

                 <asp:LinkButton ID="DeleteButton" runat="server" CausesValidation="False" 

                    CommandName="Delete" Text="删除" />

                 <asp:LinkButton ID="NewButton" runat="server" CausesValidation="False" 

                    CommandName="New" Text="新建" />

            </ItemTemplate>

        </asp:FormView>

        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 

            ConnectionString="<%$ ConnectionStrings:dgmlOAConnectionString %>" 

            DeleteCommand="DELETE FROM [Users] WHERE [loginName] = @loginName" 

            InsertCommand="INSERT INTO [Users] ([loginName], [realname], [password]) VALUES (@loginName, @realname, @password)" 

            SelectCommand="SELECT [loginName], [realname], [password] FROM [Users]" 

            UpdateCommand="UPDATE [Users] SET [realname] = @realname, [password] = @password WHERE [loginName] = @loginName">

            <DeleteParameters>

                <asp:Parameter Name="loginName" Type="String" />

            </DeleteParameters>

            <UpdateParameters>

                <asp:Parameter Name="realname" Type="String" />

                <asp:Parameter Name="password" Type="String" />

                <asp:Parameter Name="loginName" Type="String" />

            </UpdateParameters>

            <InsertParameters>

                <asp:Parameter Name="loginName" Type="String" />

                <asp:Parameter Name="realname" Type="String" />

                <asp:Parameter Name="password" Type="String" />

            </InsertParameters>

        </asp:SqlDataSource>

    

    </div>

    </form>

</body>

</html>