GridView中使用uniqueidentifier类型字段做DataKeyName

最新推荐文章于 2022-04-13 14:17:45 发布
最新推荐文章于 2022-04-13 14:17:45 发布
阅读量1.8k 收藏 1
点赞数
分类专栏： Asp.net专题 VS2005开发备忘 文章标签： asp server textbox input button string
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/hnwanghb/article/details/1876563
版权

        最近做个系统用到MemberShip来做用户权限管理，感觉Membership有点象java的acegi ！
        Membership里面有不少关键字段如：UserID,RoleID都是采用uniqueidentifier类型！
于是我在用GridView和DetailsView做一个主-从表结构程序的时候用一个UserID做为主表的
DataKeyName，用ObjectDataSource进行数据绑定，ObjectDataSource调用类UserLib的
GetUserInfo(string UserID)方法做为获取从表的数据源！
        程序跑起来出现一个什么"IConverter"异常！MS的这个报错真实恶心之极！非常不明确！
后来查了一些资料才发现，对于uniqueidentifier类型的字段做DataKeyName，关联参数要
这样写：

                    <SelectParameters>
                        <asp:ControlParameter ControlID="grvUser" Name="UserID" PropertyName="SelectedValue"
                            Type="Object" />
                    </SelectParameters>

       而且原来的GetUserInfo(string UserID)方法要改成GetUserInfo(System.Guid UserID)
       按照以上方式修改后，一切OK！部分原代码如下：

       UserManage.aspx代码：

<%@ Page Language="C#" MasterPageFile="~/Template/NormalTemplate.master" AutoEventWireup="true" CodeFile="UserManage.aspx.cs" Inherits="UserManage_UserManage" Title="学籍管理系统(Ajax版)" %>
<asp:Content ID="Content1" ContentPlaceHolderID="MainContent" Runat="Server">

        <TABLE width=500 align=center>
            <TR>
                <TD align="center">
                    <asp:Label style="TEXT-ALIGN: right" id="Label6" runat="server" ForeColor="#0000C0" Font-Bold="True">用户信息管理</asp:Label>
                </TD>
                <TD align="center">
                    <asp:Label style="TEXT-ALIGN: right" id="Label7" runat="server" ForeColor="#0000C0">当前状态:</asp:Label> <asp:Label style="TEXT-ALIGN: right" id="lblEditState" runat="server" ForeColor="#FF8000" Width="73px">新增</asp:Label>
                </TD>
            </TR>
            <TR>
                <TD bgColor=#cccccc colSpan=2 height=1></TD>
            </TR>
            <TR>
                <TD align=center>关键字<asp:TextBox id="txtKey" runat="server" Width="100px" Height="16px" CssClass="input"></asp:TextBox> <asp:Button id="btnSearch" runat="server" Width="50px" CssClass="input" CausesValidation="False" Text="查找"></asp:Button>
                </TD>
                <TD align=center>当前共:<asp:Label id="lblResultCount" runat="server" ForeColor="Red" Text="0"></asp:Label>条记录 是第<asp:Label id="lblCurPage" runat="server" ForeColor="Red" Text="0"></asp:Label>页/一共<asp:Label id="lblPage" runat="server" ForeColor="Red" Text="0"></asp:Label>页&nbsp;
                </TD>
            </TR>
            <TR>
                <TD bgColor="#cccccc" colSpan="2" height="1">
                </TD>
            </TR>
            <TR>
                <TD colSpan=2>
                   <asp:GridView id="grvUser" runat="server" DataSourceID="dsoUser" Width="100%" AllowSorting="True" DataKeyNames="UserID" AutoGenerateColumns="False" AllowPaging="True" GridLines="Vertical" CellPadding="3" BorderWidth="1px" BorderStyle="None" BorderColor="#999999" BackColor="White">
                        <FooterStyle BackColor="#CCCCCC" ForeColor="Black"></FooterStyle>
                        <Columns>
                            <asp:TemplateField HeaderText="用户名">
                                <ItemStyle Width="80px"></ItemStyle>
                                <ItemTemplate>
                                    <asp:LinkButton id="lblUserName" runat="server" Text='<%# Eval("UserName") %>' CommandName="Select"></asp:LinkButton>
                                </ItemTemplate>
                            </asp:TemplateField>                           
                            <asp:BoundField DataField="RealUserName" HeaderText="姓名">
                                <ItemStyle Width="50px" HorizontalAlign="Center"></ItemStyle>
                            </asp:BoundField>
                            <asp:TemplateField HeaderText="性别">
                                <ItemStyle Width="30px"></ItemStyle>
                                <ItemTemplate>
                                   <asp:Label ID="lblSex" runat="server" Text='<%# BindSexFormat(Eval("Sex")) %>'></asp:Label>                                                  
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:BoundField DataField="SchoolName" HeaderText="所属学校">
                                <ItemStyle Width="100px" HorizontalAlign="Center"></ItemStyle>
                            </asp:BoundField>                           
                            <asp:TemplateField HeaderText="上次登录">
                                <ItemTemplate>
                                   <asp:Label ID="lblLastActivityDate" runat="server" Text='<%# BindDateFormat(Eval("LastActivityDate")) %>'></asp:Label>                                                  
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="状态">
                                <ItemStyle Width="30px"></ItemStyle>
                                <ItemTemplate>
                                   <asp:Label ID="lblState" runat="server" Text='<%# BindStateFormat(Eval("IsApproved")) %>'></asp:Label>                                                  
                                </ItemTemplate>
                            </asp:TemplateField>
                        </Columns>
                        <RowStyle BackColor="#EEEEEE" ForeColor="Black"></RowStyle>
                        <SelectedRowStyle BackColor="#FFE0C0" BorderStyle="Solid" ForeColor="White" BorderColor="#8080FF" Font-Bold="True"></SelectedRowStyle>
                        <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center"></PagerStyle>
                        <HeaderStyle BackColor="#000084" ForeColor="White" Font-Bold="True"></HeaderStyle>
                        <AlternatingRowStyle BackColor="Gainsboro"></AlternatingRowStyle>
                     </asp:GridView>
                  </TD>
               </TR>
               <TR>
                  <TD width="45%">
                    <asp:Label style="TEXT-ALIGN: right" id="lblDetailView" runat="server" ForeColor="#0000C0" Font-Bold="True">详细考试信息</asp:Label>
                  </TD>
                  <TD>
                    <asp:Button id="btnNew" runat="server" Width="50px" CssClass="input" CausesValidation="False" Text="新增"></asp:Button>
                    <asp:Button id="btnUpdate" runat="server" Width="50px" CssClass="input" Text="修改" Visible="False"></asp:Button>
                    <asp:Button id="btnDelete" runat="server" Width="50px" CssClass="input" Text="删除" Visible="False" OnClientClick="return confirm('是否确认删除当前记录?');"></asp:Button>
                    <asp:Button id="btnSave" runat="server" Width="50px" CssClass="input" Text="保存" Visible="False"></asp:Button>
                    <asp:Button id="btnCancel" runat="server" Width="50px" CssClass="input" CausesValidation="False" Text="取消"></asp:Button>
                  </TD>
               </TR>
               <TR>
                  <TD colSpan="2">
                     <asp:DetailsView id="dtvUserInfo" runat="server" DataSourceID="dsoUserDetail" ForeColor="#333333" Width="100%" Height="50px" GridLines="None" CellPadding="4" AutoGenerateRows="False">
                        <FooterStyle BackColor="#507CD1" ForeColor="White" Font-Bold="True"></FooterStyle>
                        <CommandRowStyle BackColor="#D1DDF1" Font-Bold="True"></CommandRowStyle>
                        <EditRowStyle BackColor="White" BorderColor="#E0E0E0"></EditRowStyle>
                        <RowStyle BackColor="#EFF3FB"></RowStyle>
                        <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center"></PagerStyle>
                        <Fields>
                            <asp:TemplateField HeaderText="ID">
                                <EditItemTemplate>
                                    <asp:Label ID="lblUserID" runat="server" Text='<%# Bind("UserID") %>'></asp:Label>                          
                                </EditItemTemplate>
                                <InsertItemTemplate>       
                                </InsertItemTemplate>
                                <ItemStyle Width="380px"></ItemStyle>
                                <ItemTemplate>
                                    <asp:Label ID="lblUserID" runat="server" Text='<%# Bind("UserID") %>'></asp:Label>                        
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="用户名">
                                <EditItemTemplate>
                                    <asp:TextBox id="txtUserName_E" runat="server" Width="100px" Height="16px" CssClass="input" Text='<%# Bind("UserName") %>' MaxLength="50"></asp:TextBox>
                                    <asp:RequiredFieldValidator id="reqUserName_E" runat="server" ErrorMessage="用户名用于登录不能为空!" Display="None" ControlToValidate="txtUserName_E" SetFocusOnError="True"></asp:RequiredFieldValidator>
                                    <asp:RegularExpressionValidator id="rexUserName_E" runat="server" ErrorMessage="用户名称录入不能带'-#//%$字符!考试名称录入不能带'-#//%$字符!长度(2~30)" Display="None" ControlToValidate="txtUserName_E" ValidationExpression="[^#/-'$%]{2,30}" SetFocusOnError="True"></asp:RegularExpressionValidator>
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox id="txtUserName" runat="server" Width="100px" Height="16px" CssClass="input" Text='<%# Bind("UserName") %>' MaxLength="50"></asp:TextBox>
                                    <asp:RequiredFieldValidator id="reqUserName" runat="server" ErrorMessage="用户名用于登录不能为空!" Display="None" ControlToValidate="txtUserName" SetFocusOnError="True"></asp:RequiredFieldValidator>
                                    <asp:RegularExpressionValidator id="rexUserName" runat="server" ErrorMessage="用户名称录入不能带'-#//%$字符!长度(2~30)" Display="None" ControlToValidate="txtUserName" ValidationExpression="[^#/-'$%]{2,30}" SetFocusOnError="True"></asp:RegularExpressionValidator>
                                </InsertItemTemplate>
                                <ItemStyle Width="380px"></ItemStyle>
                                <ItemTemplate>
                                    <asp:Label id="lblUserName" runat="server" Text='<%# Eval("UserName") %>'></asp:Label>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="密码">
                                <InsertItemTemplate>
                                    <asp:TextBox id="txtPassword" runat="server" TextMode="Password" Width="100px" Height="16px" CssClass="input" Text='<%# Bind("Password") %>' MaxLength="20"></asp:TextBox>
                                    <asp:RequiredFieldValidator id="reqPassword" runat="server" ErrorMessage="密码用于登录不能为空!" Display="None" ControlToValidate="txtPassword" SetFocusOnError="True"></asp:RequiredFieldValidator>
                                    <asp:RegularExpressionValidator id="rexPassword" runat="server" ErrorMessage="密码录入不能带'-#//%$字符!长度(7~20)" Display="None" ControlToValidate="txtPassword" ValidationExpression="[^#/-'$%]{7,20}" SetFocusOnError="True"></asp:RegularExpressionValidator>
                                </InsertItemTemplate>
                                <ItemStyle Width="380px"></ItemStyle>
                                <ItemTemplate>                                   
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="密码确认">
                                <InsertItemTemplate>
                                    <asp:TextBox id="txtPasswordConfirm" runat="server" TextMode="Password" Width="100px" Height="16px" CssClass="input" Text='<%# Bind("PasswordConfirm") %>' MaxLength="20"></asp:TextBox>
                                    <asp:RequiredFieldValidator id="reqPasswordConfirm" runat="server" ErrorMessage="密码确认不能为空!" Display="None" ControlToValidate="txtPasswordConfirm" SetFocusOnError="True"></asp:RequiredFieldValidator>
                                    <asp:RegularExpressionValidator id="rexPasswordConfirm" runat="server" ErrorMessage="密码确认不能带'-#//%$字符!长度(7~20)" Display="None" ControlToValidate="txtPasswordConfirm" ValidationExpression="[^#/-'$%]{7,20}" SetFocusOnError="True"></asp:RegularExpressionValidator>
                                </InsertItemTemplate>
                                <ItemStyle Width="380px"></ItemStyle>
                                <ItemTemplate>                                   
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="真实姓名">
                                <EditItemTemplate>
                                    <asp:TextBox id="txtRealUserName_E" runat="server" Width="100px" Height="16px" CssClass="input" Text='<%# Bind("RealUserName") %>' MaxLength="50"></asp:TextBox>
                                    <asp:RequiredFieldValidator id="reqRealUserName_E" runat="server" ErrorMessage="真实姓名不能为空!" Display="None" ControlToValidate="txtRealUserName_E" SetFocusOnError="True"></asp:RequiredFieldValidator>
                                    <asp:RegularExpressionValidator id="rexRealUserName_E" runat="server" ErrorMessage="真实姓名录入不能带'-#//%$字符!真实姓名录入不能带'-#//%$字符!长度(2~30)" Display="None" ControlToValidate="txtRealUserName_E" ValidationExpression="[^#/-'$%]{2,30}" SetFocusOnError="True"></asp:RegularExpressionValidator>
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox id="txtRealUserName" runat="server" Width="100px" Height="16px" CssClass="input" Text='<%# Bind("RealUserName") %>' MaxLength="50"></asp:TextBox>
                                    <asp:RequiredFieldValidator id="reqRealUserName" runat="server" ErrorMessage="真实姓名不能为空!" Display="None" ControlToValidate="txtRealUserName" SetFocusOnError="True"></asp:RequiredFieldValidator>
                                    <asp:RegularExpressionValidator id="rexRealUserName" runat="server" ErrorMessage="真实姓名录入不能带'-#//%$字符!长度(2~30)" Display="None" ControlToValidate="txtRealUserName" ValidationExpression="[^#/-'$%]{2,30}" SetFocusOnError="True"></asp:RegularExpressionValidator>
                                </InsertItemTemplate>
                                <ItemStyle Width="380px"></ItemStyle>
                                <ItemTemplate>
                                    <asp:Label id="lblRealUserName" runat="server" Text='<%# Eval("RealUserName") %>'></asp:Label>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="性别">
                                <EditItemTemplate>
                                    <asp:DropDownList ID="cmbSex_E" runat="server" Height="16px" CssClass="input" SelectedValue='<%# Bind("Sex") %>' Width="100px" DataValueField="Sex">
                                        <asp:ListItem Text="男" Value="1"></asp:ListItem> 
                                        <asp:ListItem Text="女" Value="0"></asp:ListItem>
                                    </asp:DropDownList>                              
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:DropDownList ID="cmbSex" runat="server" CssClass="input" Height="16px"    Width="100px" DataValueField="Sex" SelectedValue='<%# Bind("Sex") %>'>
                                        <asp:ListItem Text="男" Value="1"></asp:ListItem> 
                                        <asp:ListItem Text="女" Value="0"></asp:ListItem>
                                    </asp:DropDownList>                          
                                </InsertItemTemplate>
                                <ItemStyle Width="380px"></ItemStyle>
                                <ItemTemplate>
                                    <asp:Label ID="lblSex" runat="server" Text='<%# Bind("Sex") %>'></asp:Label>                                   
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="所属角色">
                                <EditItemTemplate>
                                    <asp:DropDownList ID="cmbRoleID_E" runat="server" Height="16px" CssClass="input" SelectedValue='<%# Bind("RoleID") %>' Width="100px" DataSourceID="sdcRole" DataTextField="RoleName" DataValueField="ID">
                                </asp:DropDownList>                              
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:DropDownList ID="cmbRoleID" runat="server" CssClass="input" Height="16px"    Width="100px" DataSourceID="sdcRole" DataTextField="RoleName" DataValueField="ID" SelectedValue='<%# Bind("RoleID") %>'>
                                </asp:DropDownList>                          
                                </InsertItemTemplate>
                                <ItemStyle Width="380px"></ItemStyle>
                                <ItemTemplate>                                   
                                    <asp:Label ID="lblRoleName" runat="server" Text='<%# Bind("RoleName") %>'></asp:Label>                          
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="所属学校">
                                <EditItemTemplate>
                                    <asp:DropDownList ID="cmbSchoolID_E" runat="server" Height="16px" CssClass="input" SelectedValue='<%# Bind("SchoolID") %>' Width="100px" DataSourceID="sdcRole" DataTextField="SchoolName" DataValueField="ID">
                                </asp:DropDownList>                              
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:DropDownList ID="cmbSchoolID" runat="server" CssClass="input" Height="16px"    Width="100px" DataSourceID="sdcRole" DataTextField="SchoolName" DataValueField="ID" SelectedValue='<%# Bind("SchoolID") %>'>
                                </asp:DropDownList>                          
                                </InsertItemTemplate>
                                <ItemStyle Width="380px"></ItemStyle>
                                <ItemTemplate>                                   
                                    <asp:Label ID="lblSchoolName" runat="server" Text='<%# Bind("SchoolName") %>'></asp:Label>                          
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="电子邮件">
                                <EditItemTemplate>
                                    <asp:TextBox id="txtEmail_E" runat="server" Width="100px" Height="16px" CssClass="input" Text='<%# Bind("Email") %>' MaxLength="100"></asp:TextBox>
                                    <asp:RequiredFieldValidator id="reqEmail_E" runat="server" ErrorMessage="电子邮件录入不能为空!" Display="None" ControlToValidate="txtEmail_E" SetFocusOnError="True"></asp:RequiredFieldValidator>
                                    <asp:RegularExpressionValidator id="rexEmail_E" runat="server" ErrorMessage="电子邮件录入格式不正确!邮件录入长度(<100)" Display="None" ControlToValidate="txtEmail_E" ValidationExpression="/w+([-+.']/w+)*@/w+([-.]/w+)*/./w+([-.]/w+)*" SetFocusOnError="True"></asp:RegularExpressionValidator>
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox id="txtEmail" runat="server" Width="100px" Height="16px" CssClass="input" Text='<%# Bind("Email") %>' MaxLength="100"></asp:TextBox>
                                    <asp:RequiredFieldValidator id="reqEmail" runat="server" ErrorMessage="电子邮件录入不能为空!" Display="None" ControlToValidate="txtEmail" SetFocusOnError="True"></asp:RequiredFieldValidator>
                                    <asp:RegularExpressionValidator id="rexEmail" runat="server" ErrorMessage="电子邮件录入格式不正确!邮件录入长度(<100)" Display="None" ControlToValidate="txtEmail" ValidationExpression="/w+([-+.']/w+)*@/w+([-.]/w+)*/./w+([-.]/w+)*" SetFocusOnError="True"></asp:RegularExpressionValidator>
                                </InsertItemTemplate>
                                <ItemStyle Width="380px"></ItemStyle>
                                <ItemTemplate>
                                    <asp:Label id="lblEmail" runat="server" Text='<%# Eval("Email") %>'></asp:Label>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="找回密码问题">
                                <EditItemTemplate>
                                    <asp:TextBox id="txtQuestion_E" runat="server" Width="100px" Height="16px" CssClass="input" Text='<%# Bind("PasswordQuestion") %>' MaxLength="30"></asp:TextBox>
                                    <asp:RequiredFieldValidator id="reqQuestion_E" runat="server" ErrorMessage="找回密码问题不能为空!" Display="None" ControlToValidate="txtQuestion_E" SetFocusOnError="True"></asp:RequiredFieldValidator>
                                    <asp:RegularExpressionValidator id="rexQuestion_E" runat="server" ErrorMessage="找回密码问题不能带'-#//%$字符!长度(4~30)" Display="None" ControlToValidate="txtQuestion_E" ValidationExpression="[^#/-'$%]{4,30}" SetFocusOnError="True"></asp:RegularExpressionValidator>
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox id="txtQuestion" runat="server" Width="100px" Height="16px" CssClass="input" Text='<%# Bind("PasswordQuestion") %>' MaxLength="30"></asp:TextBox>
                                    <asp:RequiredFieldValidator id="reqQuestion" runat="server" ErrorMessage="找回密码问题不能为空!" Display="None" ControlToValidate="txtQuestion" SetFocusOnError="True"></asp:RequiredFieldValidator>
                                    <asp:RegularExpressionValidator id="rexQuestion" runat="server" ErrorMessage="找回密码问题不能带'-#//%$字符!长度(4~30)" Display="None" ControlToValidate="txtQuestion" ValidationExpression="[^#/-'$%]{4,30}" SetFocusOnError="True"></asp:RegularExpressionValidator>
                                </InsertItemTemplate>
                                <ItemStyle Width="380px"></ItemStyle>
                                <ItemTemplate>
                                    <asp:Label id="lblQuestion" runat="server" Text='<%# Eval("PasswordQuestion") %>'></asp:Label>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="问题答案">
                                <EditItemTemplate>
                                    <asp:TextBox id="txtAnswer_E" runat="server" Width="100px" Height="16px" CssClass="input" Text='<%# Bind("PasswordAnswer") %>' MaxLength="30"></asp:TextBox>
                                    <asp:RequiredFieldValidator id="reqAnswer_E" runat="server" ErrorMessage="问题答案不能为空!" Display="None" ControlToValidate="txtAnswer_E" SetFocusOnError="True"></asp:RequiredFieldValidator>
                                    <asp:RegularExpressionValidator id="rexAnswer_E" runat="server" ErrorMessage="问题答案不能带'-#//%$字符!长度(4~30)" Display="None" ControlToValidate="txtAnswer_E" ValidationExpression="[^#/-'$%]{4,30}" SetFocusOnError="True"></asp:RegularExpressionValidator>
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:TextBox id="txtAnswer" runat="server" Width="100px" Height="16px" CssClass="input" Text='<%# Bind("PasswordAnswer") %>' MaxLength="30"></asp:TextBox>
                                    <asp:RequiredFieldValidator id="reqAnswer" runat="server" ErrorMessage="问题答案不能为空!" Display="None" ControlToValidate="txtAnswer" SetFocusOnError="True"></asp:RequiredFieldValidator>
                                    <asp:RegularExpressionValidator id="rexAnswer" runat="server" ErrorMessage="问题答案不能带'-#//%$字符!长度(4~30)" Display="None" ControlToValidate="txtAnswer" ValidationExpression="[^#/-'$%]{4,30}" SetFocusOnError="True"></asp:RegularExpressionValidator>
                                </InsertItemTemplate>
                                <ItemStyle Width="380px"></ItemStyle>
                                <ItemTemplate>
                                    <asp:Label id="lblAnswer" runat="server" Text='<%# Eval("PasswordAnswer") %>'></asp:Label>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="记录创建时间">
                                <ItemStyle Width="380px"></ItemStyle>
                                <ItemTemplate>
                                    <asp:Label ID="lblCreateDate" runat="server" Text='<%# Eval("CreateDate") %>'></asp:Label>                          
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="状态">
                                <EditItemTemplate>
                                    <asp:DropDownList ID="cmbIsApproved_E" runat="server" Height="16px" CssClass="input" SelectedValue='<%# Bind("IsApproved") %>' Width="100px" DataValueField="IsApproved">
                                        <asp:ListItem Text="启用" Value="True"></asp:ListItem> 
                                        <asp:ListItem Text="停用" Value="False"></asp:ListItem>
                                    </asp:DropDownList>                              
                                </EditItemTemplate>
                                <InsertItemTemplate>
                                    <asp:DropDownList ID="cmbIsApproved" runat="server" CssClass="input" Height="16px"    Width="100px" DataValueField="IsApproved" SelectedValue='<%# Bind("IsApproved") %>'>
                                        <asp:ListItem Text="启用" Value="True"></asp:ListItem> 
                                        <asp:ListItem Text="停用" Value="False"></asp:ListItem>
                                    </asp:DropDownList>                          
                                </InsertItemTemplate>
                                <ItemStyle Width="380px"></ItemStyle>
                                <ItemTemplate>
                                    <asp:Label ID="lblIsApproved" runat="server" Text='<%# BindStateFormat(Eval("IsApproved")) %>'></asp:Label>                                   
                                </ItemTemplate>
                            </asp:TemplateField>
                        </Fields>
                        <FieldHeaderStyle BackColor="#DEE8F5" Font-Bold="True"></FieldHeaderStyle>
                        <HeaderStyle BackColor="#507CD1" ForeColor="White" Font-Bold="True"></HeaderStyle>
                        <AlternatingRowStyle BackColor="White"></AlternatingRowStyle>
                     </asp:DetailsView>
                        <asp:ValidationSummary id="ValidationSummary1" runat="server" ShowSummary="False" ShowMessageBox="True"></asp:ValidationSummary>
                     </TD>
                  </TR>
               </TABLE>
               <asp:ObjectDataSource id="dsoUser" runat="server" SelectMethod="GetUserList" TypeName="UserLib">
                    <SelectParameters>
                        <asp:ControlParameter ControlID="txtKey" DefaultValue="" Name="strKey" PropertyName="Text" Type="String" />
                    </SelectParameters>
                </asp:ObjectDataSource>
                <asp:SqlDataSource id="sdcRole" runat="server" SelectCommand="Select * From T_School_Grade Order by ID Asc" ProviderName="<%$ ConnectionStrings:MyConn.ProviderName %>" ConnectionString="<%$ ConnectionStrings:MyConn %>"></asp:SqlDataSource>
                <asp:SqlDataSource id="sdcSchool" runat="server" SelectCommand="Select * From T_Subject_Master Order by ID Asc" ProviderName="<%$ ConnectionStrings:MyConn.ProviderName %>" ConnectionString="<%$ ConnectionStrings:MyConn %>"></asp:SqlDataSource>
                <asp:ObjectDataSource id="dsoUserDetail" runat="server" SelectMethod="GetUserInfo" TypeName="UserLib" OnSelecting="dsoUserDetail_Selecting">
                    <SelectParameters>
                        <asp:ControlParameter ControlID="grvUser" Name="UserID" PropertyName="SelectedValue"
                            Type="Object" />
                    </SelectParameters>
                </asp:ObjectDataSource>

</asp:Content>

UserLib类函数：GetUserInfo

/// <summary>
    /// 根据关键字UserID获取指定ID的用户信息
    /// </summary>
    /// <param name="UserID"></param>
    /// <returns></returns>
    public DataSet GetUserInfo(System.Guid UserID)
    {
        try
        {
            string strSQL = "Select A.*,B.Email,B.CreateDate,B.IsApproved,B.PasswordQuestion,B.PasswordAnswer,C.Sex,C.RealUserName,D.SchoolName,F.RoleName,F.RoleID From Aspnet_Users A,Aspnet_MemberShip B,T_School_User C,T_School_Master D,Aspnet_UsersInRoles E,Aspnet_Roles F " +
                            " Where A.UserID=B.UserID And C.UserID=A.UserID And C.SchoolID=D.ID And E.UserID=A.UserID And F.RoleID=E.RoleID And A.UserID='" + UserID.ToString() + "'";

            return comDBAccess.SelectSQL(strSQL);
        }
        catch
        {
            return null;
        }
    }

      

 

雨夜听花
关注
专栏目录
DataKeysName的设值和取值
popo0027的专栏
09-07 666
http://topic.csdn.net/t/20061130/18/5197922.html//设置DataKeysName <asp:GridView ID="GridView1" runat="server" DataKeyNames="field1,field2,field3" 或者C#： this.GridView1.DataKeyNames = new st
GridView绑定DataKeyName以及如何取这些值
热门推荐
钟爱技术
06-23 1万+
DataKeyNames='FID'   //前台绑定一个值 GridView1.DataKeys[e.Row.RowIndex].Value.ToString; --------------------------------------------------------------------------------------------------------------------
datakeynames的设定和取值
人在江湖漂
09-30 2619
DataKeyNames就是数据库表的字段，可以设置多个。使用 DataKeyNames 属性指定表示数据源主键的字段。注意 若要以声明方式设置此属性，请使用以逗号分隔的字段名列表。 当设置了 DataKeyNames 属性时，GridView 控件用来自指定字段的值填充它的 DataKeys 集合，这提供了一种访问每个行的主键的便捷方法。注意 GridView 控件以控件状态存储这些键字段值
gridveiw中DataKeyNames属性的作用
08-20 4413
gridveiw中DataKeyNames的属性是绑定数据库中字段的
Gridview数据控件的七种字段类型
天天好心情
02-16 1350
http://blog.csdn.net/judyge/article/details/498471899.8 数据控件的七种字段类型（Fields Type）的应用GridView共支持七种字段类型，字段原本应该叫“Column”比较恰当，但ASP.NET 2.0却采用另一个名称“Field”来表示，对于名称的命名祭司认为有点不直观，因为不明的人看了根本不知道Field代表什么东西，但既然ASP
Android Studio中GridView的使用方法3-3
hou09tian的博客
04-13 2152
1.4 设置数据 在MainActivity.java中设置要显示的数据。首先，自定义一个设置数据的方法getData()，代码如下所示。 private List<Player> getData() { List<Player> data = new ArrayList<Player>(); data.add(new Player("梅西",R.mipmap.meixi)); data.add(new Player("C罗",R.mipma...
Asp.net中GridView使用详解
qhzhen的博客
09-06 5053
l         GridView无代码分页排序 l         GridView选中，编辑，取消，删除 l         GridView正反双向排序 l         GridView和下拉菜单DropDownList结合 l         GridView和CheckBox结合 l         鼠标移到GridView某一行时改变该行的背景色方法一 l      ...
Android Studio中GridView的使用方法3-1
hou09tian的博客
04-13 4021
GridView控件的作用是通过网格来显示指定的内容，如图1所示。 图1 GridView控件的使用 从图1中可以看出，GridView控件使用“网格”来显示球星。 1 GridView通过自定义Adapter显示数据 GridView控件的通过自定义Adapter显示数据的方法与《Android Studio中ListView通过自定义Adapter显示数据3-1》中提到的ListView控件相似，分为四个步骤，分别是：定义数据类、定义网格布局、定义Adapter类和设置数据。 1.1.
Android中GridView的使用方法
徐刘根的博客
05-18 3216
布局文件activity_main.xml<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:tools="http://schemas.android.com/tools" android:layout_width="match_parent" android:la
GridView中的bit类型如何进行判断的方法
qq_35306193的博客
07-17 805
今天遇到需对GridView自动生成bool类型的字段判断，数据库中的字段是bit类型的，用传统的e.Row.Cells[i].text缺取不到值，调试显示text属性为""。 后来想了想，需需要把cell列中的Controls进行转换，尝试转换成CheckBox类型，结果很欣慰转换成功！ CheckBox cb = (CheckBox)GridView1.Rows[i].Cells[5].C
Yii2-GridView 中让关联字段带搜索和排序功能示例
10-20
4. 如果需要对关联模型的字段进行搜索，可以在模型的`search`方法中使用`joinWith`方法来关联需要搜索的模型。然后在搜索条件中添加过滤条件。 知识点五：关联字段的实现方法 在Yii2中，对于关联模型的字段，需要...
Android中GridView插件的使用方法
08-26
在本文中，我们将深入探讨如何在Android应用中使用GridView插件。 首先，我们需要在布局文件中添加GridView。在给定的`activity_main.xml`中，我们看到以下代码： ```xml <GridView android:id="@+id/gridView" ...
在c#的GridView中使用邮件链接的方法.zip
最新发布
09-20
我们知道，在GridView中可以使用HyperLinkField生成一个超链接，但是这个超链接只能是普通的http的超链接， 如果想做一个邮件的链接（mailto:user@abc.com）似乎就不起作用了。通过模板列的方式实现
GridView行中按钮的使用
01-08
在ASP.NET开发中，GridView控件是一个非常常用的用于显示...以上就是关于在ASP.NET中使用GridView控件添加行内按钮以及处理行操作的基本知识。在实际应用中，可能还需要考虑错误处理、权限验证和其他用户体验优化措施。
asp.net GridView中使用RadioButton单选按钮的方法
01-02
本文实例讲述了asp.net GridView中使用RadioButton单选按钮的方法。分享给大家供大家参考，具体如下： 在GridView里做单选按钮，我用了三种方法 第一种方法：在GridView的模版列里加服务器端控件RadioButton，使用js...
关于触发asp.net Global.asax Session_End事件的经验
07-25 4310
        在做asp.net编程开发的时候，我遇见这样的问题，一个用户只能在一台机器上登录，如果有用户在其他机器上登录，系统将提示该用户已经登录！当前登陆非法！我的做法是：用Application变量保存已经Login的用户信息，当Session_Start的时候，在Global.asax文件里写Session_Start事件响应函数，记录登录用户！当用户Logout的时候，在S
Crystal Report.net Web报表开发日记(二)
02-23 4087
使用Crystal Report.net进行开发的一些预备知识:执行模式 　　水晶报表取数据可以使用下面的方法实现： 　　Pull 模式: 　　被请求时，水晶报表直接根据指定的驱动连接数据库然后组装这些数据。 　　Push 模式 : 　　此时开发表不得不自己编写代码连接数据并组装DataSet，同时将它传送至报表。在些这种情况下，通过使用连接共享以及限制记录集合的大小，可以使用报表性能最大化。 报
asp.net动态加载Ascx控件问题解决日记
04-19 4000
        在网上看了不少如何处理动态加载用户控件的文章,都没有解决我今天在开发中遇见的问题,只好自己来了 ,问题后来自己解决了,发出来给大家分享一下! 也许对其他人有用,当时的情况是这样的.        Web项目有3个ascx控件,Header.ascx,HeaderFree.ascx,HeaderLogin.ascx在网页上只放Header.ascx控件,Header.as
在IIS7下用Web.Config管理html文件的访问权限
05-07 3057
在做项目的时候，会遇到客户要求对html文件进行管理，但是，默认情况下，Web.Config只对 aspx这些asp.net的文件进行管理，html文件是管理不到的。           下面说一下我的做法，对于静态文件，如果有具体用户角色权限控制的，需要另外用程序处理。 在这里我只介绍通过Forms校验后的用户可以访问html文件，没有通过的用户，无法访问的处理控制方法。
ASP.NET GridView控件深度解析：字段类型与应用详解
本篇文章详细介绍了GridView控件的各种列字段类型以及如何在Visual Studio (VS)中进行配置。 首先，让我们来了解GridView中常用的列字段： 1. **BoundField**：这是GridView的默认列类型，主要用于显示数据源中...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值