Home / Questions / 144227
Accepted
sunflower
Asked: 2020-03-08 10:37:10 +0800 CST 2020-03-08 10:37:10 +0800 CST

How to fill gridview asp.net c# sql from behindcode? [closed]

  • 772

I have a webform application in ASP .NET with C# and I want to fill a gridview from the webform.aspx.cs. Is there a way to fill "only" when entering the page, or should it be only with a click event. Could you tell me how to do it? Thank you very much for your help Regards

c#

2 Answers

  1. Best Answer

    This is my Table or Grid in aspx (delete some columns because I use many and they are from my work...)

     <asp:GridView ID="dtg_CutWeek" runat="server" AutoGenerateColumns="False" OnRowCommand="dtg_CutWeek_RowCommand">
                    <Columns>
                        <asp:BoundField DataField="Year" HeaderText="AÑO">
                            <HeaderStyle HorizontalAlign="Center" />
                            <ItemStyle Width="50px" HorizontalAlign="Center" />
                        </asp:BoundField>

                        <asp:BoundField HeaderText="MONEDA" DataField="TC">
                            <HeaderStyle HorizontalAlign="Center" />
                            <ItemStyle Width="60px" HorizontalAlign="Center" />
                        </asp:BoundField>
                    </Columns>

    and to bind the data I do the following:

      dtg_CutWeek.DataSource = ""; // ELIMINO LOS DATOS QUE CONTENGA
    dtg_CutWeek.DataSource = dt; // ASIGNO NUEVOS DATOS QUE ESTAN EN MI dt
    dtg_CutWeek.DataBind(); //HAGO EL BINDEO DE LA INFORMACION ..

    dtg_CutWeek IS THE NAME OF MY GRID IF YOU REALIZE IT IS THE ONE I USE TO MAKE REFERENCE IN THE BACKEND

    • 0

  2. In the webform.aspx you should have something like this, where dgvData is the identifier of your GridView.

    <asp:GridView ID="dgvDatos" runat="server" AutoGenerateColumns="True">
</asp:GridView>

    In your codebehind webform.aspx.cs you should do something similar to this.

    protected void Page_Load(object sender, EventArgs e)
    {
        dgvDatos.DataSource = new Persona().Listar();
        dgvDatos.DataBind();
    }

    You can pass a Dataset from a DB, or directly a data collection as in this example.

    • 0