利用GridView 和DetailsView信息的交互实现记录的更新删除插入

 <asp:GridView ID="gvXueshengInfo" runat="server" AutoGenerateColumns="False" DataKeyNames ="xh"                  CellPadding="4" ForeColor="#333333" GridLines="None" Width="99%"                   PageSize="5" DataSourceID="SqlDataSource_GridView" AllowPaging="True" >                  <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />                  <Columns>                  <%--<asp:TemplateField><ItemTemplate><asp:CheckBox ID="chkSelected1" Checked="False" Visible="True" GroupName="chk" Runat="server"></asp:CheckBox></ItemTemplate></asp:TemplateField>--%>                

      <asp:BoundField DataField="xh" HeaderText="学号" />                     

<asp:BoundField DataField="xm" HeaderText="姓名" />                     

<asp:BoundField DataField="xb" HeaderText="性别" />                     

<asp:BoundField DataField="sfzh" HeaderText="身份证号" />               

       <asp:BoundField DataField="zymc" HeaderText="专业名称" />                 

     <asp:BoundField DataField="nj" HeaderText="年级" />                     

<asp:BoundField DataField="xxmc" HeaderText="学校名称" />                  

    <asp:BoundField DataField="xz" HeaderText="学制" />                     

<asp:BoundField DataField="xjzt" HeaderText="学籍状态" />                     

  <asp:BoundField DataField="bmbh" HeaderText="部门编号" />                   

   <asp:BoundField DataField="bmmc" HeaderText="部门名称" />                    

  <asp:TemplateField HeaderText="浏览详情">                                                

<ItemTemplate>                                                   

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

                     CommandName="Select" Text="选取"></asp:LinkButton>                                 

                </ItemTemplate>                 

   </asp:TemplateField>                 

</Columns>                 

<RowStyle BackColor="#EFF3FB" />                

  <EditRowStyle BackColor="#2461BF" />                

  <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />                 

<PagerStyle BackColor="#99C89D" ForeColor="White" HorizontalAlign="Center" />                 

<HeaderStyle BackColor="#99C89D" Font-Bold="True" ForeColor="White" />                 

<AlternatingRowStyle BackColor="White" />             

</asp:GridView>           

</td>       

</tr>       

<tr >         

<td class="style6" >             

<asp:Button ID="Button1" runat="server" Text="添加" onclick="Button1_Click" />           

</td>         

<td style="text-align: left" >             

<asp:Label ID="Label1" runat="server" Text="学号:"></asp:Label>             

<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>             

<asp:Button ID="Button2" runat="server" style="text-align: justify" Text="删除"                 

onclick="Button2_Click" Width="39px" />           

</td>       

</tr>       

<tr >         

<td class="style5" colspan="2" >             

<asp:DetailsView ID="DetailsView1" runat="server" Width="20%"    DataSourceID="SqlDataSource_GridView"                  AutoGenerateRows="False" AllowPaging="True" DataKeyNames="xh"                 >                 

<Fields>                     

<asp:BoundField DataField="xh" HeaderText="学号" InsertVisible="False"                          ReadOnly="True" SortExpression="xh" />                      <asp:BoundField DataField="xm" HeaderText="姓名" SortExpression="xm" />                     

<asp:BoundField DataField="xb" HeaderText="性别" SortExpression="xb" />                     

<asp:BoundField DataField="sfzh" HeaderText="身份证号" SortExpression="sfzh" />                     

<asp:BoundField DataField="zymc" HeaderText="专业名称" SortExpression="zymc" />                     

<asp:BoundField DataField="nj" HeaderText="年级" SortExpression="nj" />                     

<asp:BoundField DataField="xxmc" HeaderText="学校名称" SortExpression="xxmc" />                     

<asp:BoundField DataField="xz" HeaderText="学制" SortExpression="xz" />                     

<asp:BoundField DataField="xjzt" HeaderText="学籍状态" SortExpression="xjzt" />                     

<asp:BoundField DataField="bmbh" HeaderText="部门编号" SortExpression="bmbh" />                     

<asp:BoundField DataField="bmmc" HeaderText="部门名称" SortExpression="bmmc" />                                    

<asp:CommandField ShowDeleteButton="True" ShowEditButton="True"  ShowInsertButton="True" />                 

</Fields>             

<HeaderTemplate>              人员信息              </HeaderTemplate>                                     

</asp:DetailsView>              

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

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

            DeleteCommand="DELETE FROM [PersonnelInfo] WHERE [xh] = @PersonnelInfo"

            InsertCommand="INSERT INTO [PersonnelInfo] ([xm], [xb],[sfzh] ,[zymc],[nj],[xxmc],[xz],[xjzt],[bmbh],[bmmc],) VALUES (@xm, @xb,@sfzh,@zymc,@zymc,@nj,@xxmc,@xz,@xjzt,@bmbh,@bmmc,)  "

            SelectCommand="SELECT [xh], [xm], [xb] ,[sfzh] ,[zymc],[nj],[xxmc],[xz],[xjzt],[bmbh],[bmmc] FROM [PersonnelInfo]  WHERE [xh] = @xh"             UpdateCommand="UPDATE [PersonnelInfo] SET [xm] = @xm, [xb] = @xb,[sfzh]=@sfzh ,[zymc]=@zymc,[nj]=@nj,[xxmc]=@xxmc,[xz]=@xz,[xjzt]=@xjzt,[bmbh]=@bmbh,[bmmc]=@bmmc WHERE [xh] = @xh">             <SelectParameters>

                <asp:ControlParameter ControlID="gvXueshengInfo" Name="xh"

                    PropertyName="SelectedValue" />

            </SelectParameters>

            <DeleteParameters>

                <asp:Parameter Name="xh" Type="Int32" />

            </DeleteParameters>

            <UpdateParameters>                

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

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

<asp:Parameter Name="sfzh" Type="Int32" />                

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

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

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

<asp:Parameter Name="xz" Type="Int32" />                

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

<asp:Parameter Name="bmbh" Type="Int32" />                

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

<asp:Parameter Name="xh" Type="Int32" />

            </UpdateParameters>

            <InsertParameters>

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

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

<asp:Parameter Name="sfzh" Type="Int32" />                

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

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

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

<asp:Parameter Name="xz" Type="Int32" />                

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

<asp:Parameter Name="bmbh" Type="Int32" />                

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

            </InsertParameters>

        </asp:SqlDataSource>

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

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

             DeleteCommand="DELETE FROM [PersonnelInfo] WHERE [xh] = @xh"           

   InsertCommand="INSERT INTO [PersonnelInfo] ([xm], [xb],[sfzh] ,[zymc],[nj],[xxmc],[xz],[xjzt],[bmbh],[bmmc]) VALUES (@xm, @xb,@sfzh,@zymc,@nj,@xxmc,@xz,@xjzt,@bmbh,@bmmc)  "         

     UpdateCommand="UPDATE [PersonnelInfo] SET [xm] = @xm, [xb] = @xb,[sfzh]=@sfzh ,[zymc]=@zymc,[nj]=@nj,[xxmc]=@xxmc,[xz]=@xz,[xjzt]=@xjzt,[bmbh]=@bmbh,[bmmc]=@bmmc WHERE [xh] = @xh"                

                SelectCommand="SELECT [xh], [xm],[xb] ,[sfzh], [zymc], [nj], [xxmc], [xz], [xjzt], [bmbh], [bmmc] FROM [PersonnelInfo]">             <DeleteParameters>

                <asp:Parameter Name="xh" Type="Int32" />

            </DeleteParameters>        

       <InsertParameters>

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

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

     <asp:Parameter Name="sfzh" Type="Int32" />         

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

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

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

        <asp:Parameter Name="xz" Type="Int32" />             

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

   <asp:Parameter Name="bmbh" Type="Int32" />             

 

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

            </InsertParameters>       

      <UpdateParameters>              

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

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

         <asp:Parameter Name="sfzh" Type="Int32" />       

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

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

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

      <asp:Parameter Name="xz" Type="Int32" />            

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

       <asp:Parameter Name="bmbh" Type="Int32" />         

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

       <asp:Parameter Name="xh" Type="Int32" />

            </UpdateParameters>     

    </asp:SqlDataSource>