GridView手动在后台增加-删除(1)

1.先要验证是否连接数据库！

SqlConnection conn = new SqlConnection("server=.;database=cs;uid=sa;pwd=");
       
       
       //try
       //{
       //    conn.Open();
       //    if (conn.State == ConnectionState.Open)
       //    {
       //        Response.Write("数据库连接成功！");
       //    }
       //}
       //catch (Exception ee)
       //{
       //    Response.Write(ee.Message);
       //}
       //finally {
       //    conn.Close();
       //}

2.增加一个GridView控件！

紧接着一定要编辑模板

<asp:GridView ID="GridView2" runat="server" DataKeyNames="id" AutoGenerateColumns="False" OnRowEditing="GridView2_RowEditing" OnRowUpdating="GridView2_RowUpdating" OnRowDataBound="GridView2_RowDataBound" OnRowCancelingEdit="GridView2_RowCancelingEdit" OnRowDeleting="GridView2_RowDeleting">
        <Columns>
            <asp:TemplateField HeaderText="ID">
                <ItemTemplate>
                    <asp:Label ID="Label1" runat="server" Text='<%#Bind("id") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="用户名">
                <ItemTemplate>
                    <asp:Label ID="Label2" runat="server" Text='<%#Bind("txtuser") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="密码">
                <ItemTemplate>
                    <asp:Label ID="Label3" runat="server" Text='<%#Bind("txtpassword") %>'></asp:Label>
                </ItemTemplate>
                <EditItemTemplate>
                    <asp:TextBox ID="TextBox1" runat="server" Width="86px" Text='<%#Bind("txtpassword") %>'></asp:TextBox>
                </EditItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="操作">
                <ItemTemplate>
                    <asp:LinkButton ID="LinkButton1" runat="server" CommandName="edit" CommandArgument='<%#Bind("id")%>'
                        >修改</asp:LinkButton>
                </ItemTemplate>
                <EditItemTemplate>
                    <asp:LinkButton ID="LinkButton2" runat="server" CommandName="update">更新</asp:LinkButton>|<asp:LinkButton
                        ID="LinkButton3" runat="server" CommandName="cancel">取消</asp:LinkButton>
                </EditItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="删除">
                <ItemTemplate>
                    <asp:LinkButton ID="LinkButton4" runat="server" CommandName="delete">删除</asp:LinkButton>
                </ItemTemplate>
            </asp:TemplateField>
        </Columns>
    </asp:GridView>

注意：我标记红字的地方是代表3个 必须不可少的东西，万一少一个，调试出来错误，也找不到！还有text后面是单引号‘’！