ASP.NET Gridview Code: Part II - DataBinding in AutoGenerateColumns

Simple GridView data binding using C# with AutoGenerateColumns.

This article is about "GridView Code". This is my second article on Simple GridView Data Binding using C# with AutoGenerateColumns.

You can see my first article from the following link:

http://www.c-sharpcorner.com/Blogs/11296/simple-gridview-data-binding-in-Asp-Net.aspx

AutoGenerateColumns

Gets or sets a value indicating whether bound fields are automatically created for each field in the data source.

GridView Data binding with AutoGenerateColumns = true

1. When the AutoGenerateColumns property is set to true, an AutoGeneratedField object is automatically created for each field in the data source.
2. Each field is then displayed as a column in the GridView control in the order that the fields appear in the data source.
3. This option provides a convenient way to display every field in the data source; however, you have limited control of how an automatically generated column field is displayed or behaves.
4. The default is true.

Source Code

<div>
    <asp:GridView ID="grdCompany" runat="server" AutoGenerateColumns="true">
        <Columns>
            <asp:BoundField HeaderText="Id" DataField="id" />
            <asp:BoundField HeaderText="Company" DataField="company" />
            <asp:BoundField HeaderText="Address" DataField="address" />
            <asp:BoundField HeaderText="Pincode" DataField="pincode" />
        </Columns>
    </asp:GridView>
</div>

or:

<div>

    <asp:GridView ID="grdCompany" runat="server">

        <Columns>

            <asp:BoundField HeaderText="Id" DataField="id" />

            <asp:BoundField HeaderText="Company" DataField="company" />

            <asp:BoundField HeaderText="Address" DataField="address" />

            <asp:BoundField HeaderText="Pincode" DataField="pincode" />

        </Columns>

    </asp:GridView>

</div>

C# Code
 

protected void Page_Load(object sender, EventArgs e)

{

    if (!IsPostBack)

        bindGridview();

}

 

public DataTable getDataTable()

{

    DataTable dt = new DataTable();

    try

    {

        dt = new DataTable();

        dt.Columns.Add("id", typeof(int));

        dt.Columns.Add("company", typeof(string));

        dt.Columns.Add("address", typeof(string));

        dt.Columns.Add("pincode", typeof(string));

 

        dt.Rows.Add(1, "Capgemini", "Vikhroli East, Mumbai", "400 079");

        dt.Rows.Add(2, "TCS", "Tech Park, Bangalore", "560066");

        dt.Rows.Add(3, "Wipro IT", "Guindy, Chennai", "600032");

    }

    catch { throw; }

    return dt;

}

 

public void bindGridview()

{

    //grdCompany.AutoGenerateColumns = true;

    grdCompany.DataSource = getDataTable();

    grdCompany.DataBind();

}

Output



GridView Data binding with AutoGenerateColumns = false

1. You can manually define the column fields by setting the AutoGenerateColumns property to false and then creating a custom Columns collection.

2. In addition to bound column fields, you can also display a button column field, a checkbox column field, a command field, a hyperlink column field, an image field, or a column field based on your own custom-defined template.

Source Code

<div>

    <asp:GridView ID="grdCompany" runat="server" AutoGenerateColumns="false">

        <Columns>

            <asp:BoundField HeaderText="Id" DataField="id" />

            <asp:BoundField HeaderText="Company" DataField="company" />

            <asp:BoundField HeaderText="Address" DataField="address" />

            <asp:BoundField HeaderText="Pincode" DataField="pincode" />

        </Columns>

    </asp:GridView>

</div>

C# Code
 

protected void Page_Load(object sender, EventArgs e)

{

    if (!IsPostBack)

        bindGridview();

}

 

public DataTable getDataTable()

{

    DataTable dt = new DataTable();

    try

    {

        dt = new DataTable();

        dt.Columns.Add("id", typeof(int));

        dt.Columns.Add("company", typeof(string));

        dt.Columns.Add("address", typeof(string));

        dt.Columns.Add("pincode", typeof(string));

 

        dt.Rows.Add(1, "Capgemini", "Vikhroli East, Mumbai", "400 079");

        dt.Rows.Add(2, "TCS", "Tech Park, Bangalore", "560066");

        dt.Rows.Add(3, "Wipro IT", "Guindy, Chennai", "600032");

    }

    catch { throw; }

    return dt;

}

 

public void bindGridview()

{

    //grdCompany.AutoGenerateColumns = false;

    grdCompany.DataSource = getDataTable();

    grdCompany.DataBind();

}

Output