在gridview中添加新行

本文介绍了在gridview中添加新行的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

我有一个gridview和一个提交按钮(代码中没有).

我想在单击提交按钮时在gridview中显示名称，empno和当前日期和时间.
记录也应显示在具有当前日期和时间的新行中.

我只需要日期和时间方面的帮助+添加新行.

我该怎么做?
请帮忙.

I have a gridview and a submit button(not in the code).

I want to show name, empno and current date and time in the gridview whenever I click submit button.
Also records should appear in a new row with current date and time.

I just need help with date and time + adding a new row.

How can I do it?
Please help.

<asp:GridView ID="gv_addrow" runat="server" AutoGenerateColumns="False"

        CellPadding="4" ForeColor="#333333" GridLines="None">
        <AlternatingRowStyle BackColor="White" />
        <Columns>
            <asp:TemplateField HeaderText="S.NO.">
                <ItemTemplate>
                   <%# ((GridViewRow) Container).RowIndex  + 1 %>
                </ItemTemplate>

            </asp:TemplateField>

            <asp:TemplateField HeaderText="ID ">

                <ItemTemplate>
                    <asp:Label ID="Label1" runat="server" Text='<%# Bind("EMPNO") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Name">

                <ItemTemplate>
                    <asp:Label ID="Label2" runat="server" Text='<%# Bind("NAME") %>'></asp:Label>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Checked Date">

                <ItemTemplate>
                    <asp:Label ID="Label3" runat="server"></asp:Label>
                    <%=System.DateTime.Now%>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Time">

                <ItemTemplate>
                    <asp:Label ID="Label4" runat="server"></asp:Label>
                        <%=System.DateTime.Now.Month %>
                </ItemTemplate>
            </asp:TemplateField>
        </Columns>
        <EditRowStyle BackColor="#2461BF" />
        <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
        <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
        <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
        <RowStyle BackColor="#EFF3FB" />
        <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
        <SortedAscendingCellStyle BackColor="#F5F7FB" />
        <SortedAscendingHeaderStyle BackColor="#6D95E1" />
        <SortedDescendingCellStyle BackColor="#E9EBEF" />
        <SortedDescendingHeaderStyle BackColor="#4870BE" />
    </asp:GridView>

代码:

Code :

public void ADD_getDetail()
    {



        SqlConnection con = new SqlConnection(s);
        con.Open();
        SqlCommand cmd = new SqlCommand("select EMPNO, NAME from zemp_s_web_al where EMPNO = " + "'" + EmpCode.Trim() + "'", con);
        //List<sqlparameter> paramList = new List<sqlparameter>();
        //paramList.Add(new SqlParameter("@EMPCODE", EmpCode));
        //cmd.Parameters.AddRange(paramList.ToArray());
        SqlDataAdapter da = new SqlDataAdapter(cmd);

        DataTable dt = new DataTable();
            da.Fill(dt);

        gv_addrow.DataSource = dt;
        gv_addrow.DataBind();

        con.Close();

    }</sqlparameter></sqlparameter>

gridview

在gridview中添加新行

问题描述

推荐答案