如何将SQl DB更新，插入，Gridview值 [英] How to Update, Insert, Gridview Values to SQl DB

问题描述

这是我之前的报价的源代码，

如果代码中有任何错误，请更正.

Hi,

Here is my Source code for the previous quation,

Please make corrections if there any mistakes in the code.

<asp:GridView ID="GridView1" runat="server"  DataKeyNames="EmpNo"

            AllowPaging="true" AllowSorting="true" PageSize="5"

            onpageindexchanging="GridView1_PageIndexChanging"

            onrowcancelingedit="GridView1_RowCancelingEdit"

            onrowdeleting="GridView1_RowDeleting" onrowediting="GridView1_RowEditing"

            onrowupdating="GridView1_RowUpdating"

            onselectedindexchanged="GridView1_SelectedIndexChanged"

            onsorting="GridView1_Sorting" EnableModelValidation="true"

            AutoGenerateColumns="false" onrowcommand="GridView1_RowCommand"

            ShowFooter="true" onrowdatabound="GridView1_RowDataBound">
            <RowStyle HorizontalAlign="Center" />
            <AlternatingRowStyle BackColor="White" />
            <EditRowStyle BackColor="#7C6F57" />
            <FooterStyle BackColor="#1C5E55" ForeColor="White" Font-Bold="True" />
            <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
            <RowStyle BackColor="#E3EAEB" />
            <SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />

           <Columns>
<asp:TemplateField HeaderText="EmpNo" SortExpression="EmpNo" HeaderStyle-HorizontalAlign="Left"><EditItemTemplate>
<asp:TextBox ID="txtEmNo" runat="server" Text='<%#Eval("EmpNo") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtEmpNo" runat="server"/>
</FooterTemplate>
<ItemTemplate>
<asp:Label ID="lblitemNo" runat="server" Text='<%#Eval("EmpNo") %>'/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="EmpName" SortExpression="EmpName" HeaderStyle-HorizontalAlign="Left">
<EditItemTemplate>
<asp:TextBox ID="txtEmpName" runat="server" Text='<%#Eval("EmpName") %>'></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator6" runat="server" ControlToValidate="txtEmpName" ValidationGroup="Add New"  ErrorMessage="Must Enter Emp Name"></asp:RequiredFieldValidator>
<span><asp:RegularExpressionValidator ID="RegExpValidator" runat="server" ControlToValidate="txtEmpName" ValidationGroup="Add New" ValidationExpression="^[A-Z a-z]+$" ErrorMessage="Only Charecters and white space are allowed">
</asp:RegularExpressionValidator></span>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtEmpName" runat="server"/>
<asp:RequiredFieldValidator ID="RequiredFieldValidator6" runat="server" ControlToValidate="txtEmpName" ValidationGroup="Add New"  ErrorMessage="Must Enter Emp Name"></asp:RequiredFieldValidator>
<span><asp:RegularExpressionValidator ID="RegExpValidator" runat="server" ControlToValidate="txtEmpName" ValidationGroup="Add New" ValidationExpression="^[A-Z a-z]+$" ErrorMessage="Only Charecters and white space are allowed">
</asp:RegularExpressionValidator></span>
</FooterTemplate>
<ItemTemplate>
<asp:Label ID="lblitemName" runat="server" Text='<%#Eval("EmpName") %>'/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Designation" HeaderStyle-HorizontalAlign="Left" SortExpression="Designation">
<ItemTemplate><%# Eval("Designation") %></ItemTemplate>
<EditItemTemplate>
<asp:DropDownList ID="dropDesg" runat="server" SelectedValue='<%# Eval("Designation").ToString() %>'>
<asp:ListItem Selected="True">Select Designation</asp:ListItem>
<asp:ListItem Text="Manager" Value="Manager"></asp:ListItem>
<asp:ListItem Text="Asis Manager" Value="Asis Manager"></asp:ListItem>
<asp:ListItem Text="Sales Rep" Value="Sales Rep"></asp:ListItem>
</asp:DropDownList>
</EditItemTemplate>
<FooterTemplate>
<asp:DropDownList ID="dropDesg" runat="server">
<asp:ListItem Selected="True">Select Designation</asp:ListItem>
<asp:ListItem Text="Manager" Value="Manager"></asp:ListItem>
<asp:ListItem Text="Asis Manager" Value="Asis Manager"></asp:ListItem>
<asp:ListItem Text="Sales Rep" Value="Sales Rep"></asp:ListItem>
</asp:DropDownList>
</FooterTemplate>
</asp:TemplateField>

<%--<asp:TemplateField HeaderText="Designation" SortExpression="Designation"><EditItemTemplate>
<asp:TextBox ID="txtDesg" runat="server" Text='<%#Eval("Designation") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtDesg" runat="server"/>
</FooterTemplate>
<ItemTemplate>
<asp:Label ID="lblitemDesg" runat="server" Text='<%#Eval("Designation") %>'/>
</ItemTemplate>
</asp:TemplateField>--%>
<%--<asp:TemplateField HeaderText="Department" SortExpression="Department"><EditItemTemplate>
<asp:TextBox ID="txtDep" runat="server" Text='<%#Eval("Department") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtDep" runat="server"/>
</FooterTemplate>
<ItemTemplate>
<asp:Label ID="lblitemDep" runat="server" Text='<%#Eval("Department") %>'/>
</ItemTemplate>
</asp:TemplateField>--%>

<asp:TemplateField HeaderText="Department" HeaderStyle-HorizontalAlign="Left" SortExpression="Department">
<ItemTemplate><%# Eval("Department") %></ItemTemplate>
<EditItemTemplate>
<asp:DropDownList ID="ddlDep" runat="server" SelectedValue='<%# Eval("Department").ToString() %>'>
<asp:ListItem Selected="True">Select Department</asp:ListItem>
<asp:ListItem Text="Accounts" Value="Accounts"></asp:ListItem>
<asp:ListItem Text="Sales" Value="Sales"></asp:ListItem>
</asp:DropDownList>
</EditItemTemplate>
<FooterTemplate>
<asp:DropDownList ID="ddlDep" runat="server">
<asp:ListItem Selected="True">Select Department</asp:ListItem>
<asp:ListItem Text="Accounts" Value="Accounts"></asp:ListItem>
<asp:ListItem Text="Sales" Value="Sales"></asp:ListItem>
</asp:DropDownList>
</FooterTemplate>
</asp:TemplateField>

<asp:TemplateField HeaderText="Salary" HeaderStyle-HorizontalAlign="Left"><EditItemTemplate>
<asp:TextBox ID="txtSal" runat="server" ValidationGroup="Add New" Text='<%#Eval("Salary") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtSal" runat="server" ValidationGroup="Add New"/>
<asp:RequiredFieldValidator ID="ReqGV5" runat="server" ValidationGroup="Add New"

        ControlToValidate="txtSal"

        ErrorMessage=" Enter salary with numeric values"></asp:RequiredFieldValidator>
<span>
    <asp:RangeValidator ID="RangeGV1" runat="server"

        Type="Double" ValidationGroup="Add New" ControlToValidate="txtSal"

        MinimumValue="10000.00" MaximumValue="60000.00"

        ErrorMessage =" Must be in the range between 20000.00 to 50000.00"></asp:RangeValidator></span>
</FooterTemplate>
<ItemTemplate>
<asp:Label ID="lblitemSal" runat="server" Text='<%#Eval("Salary") %>'/>
</ItemTemplate>
</asp:TemplateField>
<%--<asp:TemplateField HeaderText="Gender" SortExpression="Gender"><EditItemTemplate>
<asp:TextBox ID="txtGen" runat="server"  Text='<%#Eval("Gender") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtGen" runat="server"/>
</FooterTemplate>
<ItemTemplate>
<asp:Label ID="lblitemGen" runat="server" Text='<%#Eval("Gender") %>'/>
</ItemTemplate>
</asp:TemplateField>--%>

<asp:TemplateField HeaderText="Gender" HeaderStyle-HorizontalAlign="Left">
<ItemTemplate>
<%# Eval("Gender")%>
</ItemTemplate>
<EditItemTemplate>
<asp:RadioButtonList ID="RBLGender" runat="server" RepeatDirection="Horizontal" SelectedValue='<%# Eval("Gender") %>'>
<asp:ListItem Value="Male">Male</asp:ListItem>
<asp:ListItem Value="Female">Female</asp:ListItem>
</asp:RadioButtonList>
</EditItemTemplate>
<FooterTemplate>
<asp:RadioButtonList ID="RBLGender" runat="server">
<asp:ListItem Value="Male">Male</asp:ListItem>
<asp:ListItem Value="Female">Female</asp:ListItem>
</asp:RadioButtonList>
</FooterTemplate>
</asp:TemplateField>

<%--<asp:TemplateField HeaderText="Preference"  SortExpression="Preference"><EditItemTemplate>
<asp:TextBox ID="txtPref" runat="server" Text='<%#Eval("Preference") %>'></asp:TextBox>
</EditItemTemplate>
<FooterTemplate>
<asp:TextBox ID="txtPref" runat="server"/>
</FooterTemplate>
<ItemTemplate>
<asp:Label ID="lblitemPref" runat="server" Text='<%#Eval("Preference") %>'/>
</ItemTemplate>
</asp:TemplateField>--%>

<asp:TemplateField HeaderText="Preference" HeaderStyle-HorizontalAlign="Left">
<ItemTemplate><%# Eval("Preference") %></ItemTemplate>
<EditItemTemplate>
<asp:CheckBoxList ID="CheckBoxList1" runat="server" SelectedValue='<%# Eval("Preference").ToString() %>'>
<asp:ListItem>Coffee</asp:ListItem>
<asp:ListItem>Tea</asp:ListItem>
<asp:ListItem>Cool Drink</asp:ListItem>
</asp:CheckBoxList>
</EditItemTemplate>
<FooterTemplate>
<asp:CheckBoxList ID="CheckBoxList1" runat="server">
<asp:ListItem>Coffee</asp:ListItem>
<asp:ListItem>Tea</asp:ListItem>
<asp:ListItem>Cool Drink</asp:ListItem>
</asp:CheckBoxList>
</FooterTemplate>
</asp:TemplateField>

推荐答案

" ErrorMessage="Only Charecters and white space are allowed"> </asp:RegularExpressionValidator></span> < /EditItemTemplate > < FooterTemplate > <asp:TextBox ID="txtEmpName" runat="server"/> <asp:RequiredFieldValidator ID="RequiredFieldValidator6" runat="server" ControlToValidate="txtEmpName" ValidationGroup="Add New" ErrorMessage="Must Enter Emp Name"></asp:RequiredFieldValidator> <span><asp:RegularExpressionValidator ID="RegExpValidator" runat="server" ControlToValidate="txtEmpName" ValidationGroup="Add New" ValidationExpression="^[A-Z a-z]+

" ErrorMessage="Only Charecters and white space are allowed"> </asp:RegularExpressionValidator></span> </EditItemTemplate> <FooterTemplate> <asp:TextBox ID="txtEmpName" runat="server"/> <asp:RequiredFieldValidator ID="RequiredFieldValidator6" runat="server" ControlToValidate="txtEmpName" ValidationGroup="Add New" ErrorMessage="Must Enter Emp Name"></asp:RequiredFieldValidator> <span><asp:RegularExpressionValidator ID="RegExpValidator" runat="server" ControlToValidate="txtEmpName" ValidationGroup="Add New" ValidationExpression="^[A-Z a-z]+

" ErrorMessage="Only Charecters and white space are allowed"> </asp:RegularExpressionValidator></span> < /FooterTemplate > < ItemTemplate > <asp:Label ID="lblitemName" runat="server" Text='<%#Eval("EmpName") %>'/> < /ItemTemplate > < /asp:TemplateField > <asp:TemplateField HeaderText="Designation" HeaderStyle-HorizontalAlign="Left" SortExpression="Designation"> <ItemTemplate><%# Eval("Designation") %></ItemTemplate> < EditItemTemplate > <asp:DropDownList ID="dropDesg" runat="server" SelectedValue='<%# Eval("Designation").ToString() %>'> <asp:ListItem Selected="True">Select Designation</asp:ListItem> <asp:ListItem Text="Manager" Value="Manager"></asp:ListItem> <asp:ListItem Text="Asis Manager" Value="Asis Manager"></asp:ListItem> <asp:ListItem Text="Sales Rep" Value="Sales Rep"></asp:ListItem> < /asp:DropDownList > < /EditItemTemplate > < FooterTemplate > <asp:DropDownList ID="dropDesg" runat="server"> <asp:ListItem Selected="True">Select Designation</asp:ListItem> <asp:ListItem Text="Manager" Value="Manager"></asp:ListItem> <asp:ListItem Text="Asis Manager" Value="Asis Manager"></asp:ListItem> <asp:ListItem Text="Sales Rep" Value="Sales Rep"></asp:ListItem> < /asp:DropDownList > < /FooterTemplate > < /asp:TemplateField > <%--<asp:TemplateField HeaderText="Designation" SortExpression="Designation"><EditItemTemplate> <asp:TextBox ID="txtDesg" runat="server" Text='<%#Eval("Designation") %>'></asp:TextBox> < /EditItemTemplate > < FooterTemplate > <asp:TextBox ID="txtDesg" runat="server"/> < /FooterTemplate > < ItemTemplate > <asp:Label ID="lblitemDesg" runat="server" Text='<%#Eval("Designation") %>'/> < /ItemTemplate > < /asp:TemplateField > -％> <%--<asp:TemplateField HeaderText="Department" SortExpression="Department"><EditItemTemplate> <asp:TextBox ID="txtDep" runat="server" Text='<%#Eval("Department") %>'></asp:TextBox> < /EditItemTemplate > < FooterTemplate > <asp:TextBox ID="txtDep" runat="server"/> < /FooterTemplate > < ItemTemplate > <asp:Label ID="lblitemDep" runat="server" Text='<%#Eval("Department") %>'/> < /ItemTemplate > < /asp:TemplateField > -％> <asp:TemplateField HeaderText="Department" HeaderStyle-HorizontalAlign="Left" SortExpression="Department"> <ItemTemplate><%# Eval("Department") %></ItemTemplate> < EditItemTemplate > <asp:DropDownList ID="ddlDep" runat="server" SelectedValue='<%# Eval("Department").ToString() %>'> <asp:ListItem Selected="True">Select Department</asp:ListItem> <asp:ListItem Text="Accounts" Value="Accounts"></asp:ListItem> <asp:ListItem Text="Sales" Value="Sales"></asp:ListItem> < /asp:DropDownList > < /EditItemTemplate > < FooterTemplate > <asp:DropDownList ID="ddlDep" runat="server"> <asp:ListItem Selected="True">Select Department</asp:ListItem> <asp:ListItem Text="Accounts" Value="Accounts"></asp:ListItem> <asp:ListItem Text="Sales" Value="Sales"></asp:ListItem> < /asp:DropDownList > < /FooterTemplate > < /asp:TemplateField > <asp:TemplateField HeaderText="Salary" HeaderStyle-HorizontalAlign="Left"><EditItemTemplate> <asp:TextBox ID="txtSal" runat="server" ValidationGroup="Add New" Text='<%#Eval("Salary") %>'></asp:Text框 > < /EditItemTemplate > < FooterTemplate > <asp:TextBox ID="txtSal" runat="server" ValidationGroup="Add New"/> <asp:RequiredFieldValidator ID="ReqGV5" runat="server" ValidationGroup="Add New" ControlToValidate="txtSal" ErrorMessage=" Enter salary with numeric values"></asp:RequiredFieldValidator> < span > <asp:RangeValidator ID="RangeGV1" runat="server" Type="Double" ValidationGroup="Add New" ControlToValidate="txtSal" MinimumValue="10000.00" MaximumValue="60000.00" ErrorMessage =" Must be in the range between 20000.00 to 50000.00"></asp:RangeValidator></span> < /FooterTemplate > < ItemTemplate > <asp:Label ID="lblitemSal" runat="server" Text='<%#Eval("Salary") %>'/> < /ItemTemplate > < /asp:TemplateField > <%--<asp:TemplateField HeaderText="Gender" SortExpression="Gender"><EditItemTemplate> <asp:TextBox ID="txtGen" runat="server" Text='<%#Eval("Gender") %>'></asp:TextBox> < /EditItemTemplate > < FooterTemplate > <asp:TextBox ID="txtGen" runat="server"/> < /FooterTemplate > < ItemTemplate > <asp:Label ID="lblitemGen" runat="server" Text='<%#Eval("Gender") %>'/> < /ItemTemplate > < /asp:TemplateField > -％> <asp:TemplateField HeaderText="Gender" HeaderStyle-HorizontalAlign="Left"> < ItemTemplate > <%# Eval("Gender")%> < /ItemTemplate > < EditItemTemplate > <asp:RadioButtonList ID="RBLGender" runat="server" RepeatDirection="Horizontal" SelectedValue='<%# Eval("Gender") %>'> <asp:ListItem Value="Male">Male</asp:ListItem> <asp:ListItem Value="Female">Female</asp:ListItem> < /asp:RadioButtonList > < /EditItemTemplate > < FooterTemplate > <asp:RadioButtonList ID="RBLGender" runat="server"> <asp:ListItem Value="Male">Male</asp:ListItem> <asp:ListItem Value="Female">Female</asp:ListItem> < /asp:RadioButtonList > < /FooterTemplate > < /asp:TemplateField > <%--<asp:TemplateField HeaderText="Preference" SortExpression="Preference"><EditItemTemplate> <asp:TextBox ID="txtPref" runat="server" Text='<%#Eval("Preference") %>'></asp:TextBox> < /EditItemTemplate > < FooterTemplate > <asp:TextBox ID="txtPref" runat="server"/> < /FooterTemplate > < ItemTemplate > <asp:Label ID="lblitemPref" runat="server" Text='<%#Eval("Preference") %>'/> < /ItemTemplate > < /asp:TemplateField > -％> <asp:TemplateField HeaderText="Preference" HeaderStyle-HorizontalAlign="Left"> <ItemTemplate><%# Eval("Preference") %></ItemTemplate> < EditItemTemplate > <asp:CheckBoxList ID="CheckBoxList1" runat="server" SelectedValue='<%# Eval("Preference").ToString() %>'> <asp:ListItem>Coffee</asp:ListItem> <asp:ListItem>Tea</asp:ListItem> <asp:ListItem>Cool Drink</asp:ListItem> < /asp:CheckBoxList > < /EditItemTemplate > < FooterTemplate > < asp:CheckBoxList ID =" runat 服务器" <asp:ListItem>Coffee</asp:ListItem> <asp:ListItem>Tea</asp:ListItem> <asp:ListItem>Cool Drink</asp:ListItem> < /asp:CheckBoxList > < /FooterTemplate > < /asp:TemplateField >

" ErrorMessage="Only Charecters and white space are allowed"> </asp:RegularExpressionValidator></span> </FooterTemplate> <ItemTemplate> <asp:Label ID="lblitemName" runat="server" Text='<%#Eval("EmpName") %>'/> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Designation" HeaderStyle-HorizontalAlign="Left" SortExpression="Designation"> <ItemTemplate><%# Eval("Designation") %></ItemTemplate> <EditItemTemplate> <asp:DropDownList ID="dropDesg" runat="server" SelectedValue='<%# Eval("Designation").ToString() %>'> <asp:ListItem Selected="True">Select Designation</asp:ListItem> <asp:ListItem Text="Manager" Value="Manager"></asp:ListItem> <asp:ListItem Text="Asis Manager" Value="Asis Manager"></asp:ListItem> <asp:ListItem Text="Sales Rep" Value="Sales Rep"></asp:ListItem> </asp:DropDownList> </EditItemTemplate> <FooterTemplate> <asp:DropDownList ID="dropDesg" runat="server"> <asp:ListItem Selected="True">Select Designation</asp:ListItem> <asp:ListItem Text="Manager" Value="Manager"></asp:ListItem> <asp:ListItem Text="Asis Manager" Value="Asis Manager"></asp:ListItem> <asp:ListItem Text="Sales Rep" Value="Sales Rep"></asp:ListItem> </asp:DropDownList> </FooterTemplate> </asp:TemplateField> <%--<asp:TemplateField HeaderText="Designation" SortExpression="Designation"><EditItemTemplate> <asp:TextBox ID="txtDesg" runat="server" Text='<%#Eval("Designation") %>'></asp:TextBox> </EditItemTemplate> <FooterTemplate> <asp:TextBox ID="txtDesg" runat="server"/> </FooterTemplate> <ItemTemplate> <asp:Label ID="lblitemDesg" runat="server" Text='<%#Eval("Designation") %>'/> </ItemTemplate> </asp:TemplateField>--%> <%--<asp:TemplateField HeaderText="Department" SortExpression="Department"><EditItemTemplate> <asp:TextBox ID="txtDep" runat="server" Text='<%#Eval("Department") %>'></asp:TextBox> </EditItemTemplate> <FooterTemplate> <asp:TextBox ID="txtDep" runat="server"/> </FooterTemplate> <ItemTemplate> <asp:Label ID="lblitemDep" runat="server" Text='<%#Eval("Department") %>'/> </ItemTemplate> </asp:TemplateField>--%> <asp:TemplateField HeaderText="Department" HeaderStyle-HorizontalAlign="Left" SortExpression="Department"> <ItemTemplate><%# Eval("Department") %></ItemTemplate> <EditItemTemplate> <asp:DropDownList ID="ddlDep" runat="server" SelectedValue='<%# Eval("Department").ToString() %>'> <asp:ListItem Selected="True">Select Department</asp:ListItem> <asp:ListItem Text="Accounts" Value="Accounts"></asp:ListItem> <asp:ListItem Text="Sales" Value="Sales"></asp:ListItem> </asp:DropDownList> </EditItemTemplate> <FooterTemplate> <asp:DropDownList ID="ddlDep" runat="server"> <asp:ListItem Selected="True">Select Department</asp:ListItem> <asp:ListItem Text="Accounts" Value="Accounts"></asp:ListItem> <asp:ListItem Text="Sales" Value="Sales"></asp:ListItem> </asp:DropDownList> </FooterTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Salary" HeaderStyle-HorizontalAlign="Left"><EditItemTemplate> <asp:TextBox ID="txtSal" runat="server" ValidationGroup="Add New" Text='<%#Eval("Salary") %>'></asp:TextBox> </EditItemTemplate> <FooterTemplate> <asp:TextBox ID="txtSal" runat="server" ValidationGroup="Add New"/> <asp:RequiredFieldValidator ID="ReqGV5" runat="server" ValidationGroup="Add New" ControlToValidate="txtSal" ErrorMessage=" Enter salary with numeric values"></asp:RequiredFieldValidator> <span> <asp:RangeValidator ID="RangeGV1" runat="server" Type="Double" ValidationGroup="Add New" ControlToValidate="txtSal" MinimumValue="10000.00" MaximumValue="60000.00" ErrorMessage =" Must be in the range between 20000.00 to 50000.00"></asp:RangeValidator></span> </FooterTemplate> <ItemTemplate> <asp:Label ID="lblitemSal" runat="server" Text='<%#Eval("Salary") %>'/> </ItemTemplate> </asp:TemplateField> <%--<asp:TemplateField HeaderText="Gender" SortExpression="Gender"><EditItemTemplate> <asp:TextBox ID="txtGen" runat="server" Text='<%#Eval("Gender") %>'></asp:TextBox> </EditItemTemplate> <FooterTemplate> <asp:TextBox ID="txtGen" runat="server"/> </FooterTemplate> <ItemTemplate> <asp:Label ID="lblitemGen" runat="server" Text='<%#Eval("Gender") %>'/> </ItemTemplate> </asp:TemplateField>--%> <asp:TemplateField HeaderText="Gender" HeaderStyle-HorizontalAlign="Left"> <ItemTemplate> <%# Eval("Gender")%> </ItemTemplate> <EditItemTemplate> <asp:RadioButtonList ID="RBLGender" runat="server" RepeatDirection="Horizontal" SelectedValue='<%# Eval("Gender") %>'> <asp:ListItem Value="Male">Male</asp:ListItem> <asp:ListItem Value="Female">Female</asp:ListItem> </asp:RadioButtonList> </EditItemTemplate> <FooterTemplate> <asp:RadioButtonList ID="RBLGender" runat="server"> <asp:ListItem Value="Male">Male</asp:ListItem> <asp:ListItem Value="Female">Female</asp:ListItem> </asp:RadioButtonList> </FooterTemplate> </asp:TemplateField> <%--<asp:TemplateField HeaderText="Preference" SortExpression="Preference"><EditItemTemplate> <asp:TextBox ID="txtPref" runat="server" Text='<%#Eval("Preference") %>'></asp:TextBox> </EditItemTemplate> <FooterTemplate> <asp:TextBox ID="txtPref" runat="server"/> </FooterTemplate> <ItemTemplate> <asp:Label ID="lblitemPref" runat="server" Text='<%#Eval("Preference") %>'/> </ItemTemplate> </asp:TemplateField>--%> <asp:TemplateField HeaderText="Preference" HeaderStyle-HorizontalAlign="Left"> <ItemTemplate><%# Eval("Preference") %></ItemTemplate> <EditItemTemplate> <asp:CheckBoxList ID="CheckBoxList1" runat="server" SelectedValue='<%# Eval("Preference").ToString() %>'> <asp:ListItem>Coffee</asp:ListItem> <asp:ListItem>Tea</asp:ListItem> <asp:ListItem>Cool Drink</asp:ListItem> </asp:CheckBoxList> </EditItemTemplate> <FooterTemplate> <asp:CheckBoxList ID="CheckBoxList1" runat="server"> <asp:ListItem>Coffee</asp:ListItem> <asp:ListItem>Tea</asp:ListItem> <asp:ListItem>Cool Drink</asp:ListItem> </asp:CheckBoxList> </FooterTemplate> </asp:TemplateField>

这篇关于如何将SQl DB更新，插入，Gridview值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！