How to Add Multiple Data Columns To A Datatable At Once using ASP.NET

Add multiple DataColumns to a DataTable using ASP.NET

Output:

How to Add Multiple Data Columns To A Datatable At Once

ASP.NET Code:


<%@ Page Language="C#" AutoEventWireup="true" %>
<%@ Import Namespace="System.Data" %>
<!DOCTYPE html>
<script runat="server">
    void Button1_Click(object sender, System.EventArgs e)
    {
        DataTable dt = new DataTable();
        dt.TableName = "Books";
        
        DataColumn dc = new DataColumn();
        dc.ColumnName = "BookID";
        dc.DataType = typeof(int);
        //this line add single DataColumn to DataTable
        dt.Columns.Add(dc);

        DataColumn dc2 = new DataColumn();
        dc2.ColumnName = "BookName";
        dc2.DataType = typeof(string);

        DataColumn dc3 = new DataColumn();
        dc3.ColumnName = "BookPrice";
        dc3.DataType = typeof(decimal);
        
        //this line add two DataColumn to DataTable at a time
        dt.Columns.AddRange(new DataColumn[] {dc2,dc3});

        dt.Rows.Add(new object[] { 1,"asp.net ebook",4 });
        dt.Rows.Add(new object[] { 2, "ajax ebook",5.05 });

        GridView1.DataSource = dt;
        GridView1.DataBind();
    }
</script>
<html lang="en-US">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
    <title> CODE4EXAMPLE.COM </title>
    <link href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css" rel="stylesheet">
</head>

	<body>
        <div class="container">
        <form id="form1" runat="server">
            <h2 style="color:DarkBlue; font-style:italic;">
                Using AddRange() method - How to add multiple
                <br /> DataColumn to a DataTable programmatically in ado.net
            </h2>
            <hr align="left" color="CornFlowerBlue" />
            <asp:GridView 
                ID="GridView1"
                runat="server"
                CssClass="table table-striped table-dark" 
                >
            </asp:GridView>
            <br />
            <asp:Button 
                ID="Button2"
                runat="server"
                OnClick="Button1_Click"
                Text="Populate GridView"
                CssClass="btn btn-primary btn-lg" 
                />
        </form>    
        </div>  
</body>
</html>

<%@ Page Language="C#" AutoEventWireup="true" %>

<%@ Import Namespace="System.Data" %>

<!DOCTYPE html>

void Button1_Click(object sender, System.EventArgs e)

{

DataTable dt = new DataTable();

dt.TableName = "Books";

DataColumn dc = new DataColumn();

dc.ColumnName = "BookID";

dc.DataType = typeof(int);

//this line add single DataColumn to DataTable

dt.Columns.Add(dc);

DataColumn dc2 = new DataColumn();

dc2.ColumnName = "BookName";

dc2.DataType = typeof(string);

DataColumn dc3 = new DataColumn();

dc3.ColumnName = "BookPrice";

dc3.DataType = typeof(decimal);

//this line add two DataColumn to DataTable at a time

dt.Columns.AddRange(new DataColumn[] {dc2,dc3});

dt.Rows.Add(new object[] { 1,"asp.net ebook",4 });

dt.Rows.Add(new object[] { 2, "ajax ebook",5.05 });

GridView1.DataSource = dt;

GridView1.DataBind();

}

</script>

<head>

<title> CODE4EXAMPLE.COM </title>

</head>

<body>

Using AddRange() method - How to add multiple

<br /> DataColumn to a DataTable programmatically in ado.net

</h2>

<asp:GridView

ID="GridView1"

runat="server"

CssClass="table table-striped table-dark"

</asp:GridView>

<br />

<asp:Button

ID="Button2"

runat="server"

OnClick="Button1_Click"

Text="Populate GridView"

CssClass="btn btn-primary btn-lg"

</form>

</div>

</body>

</html>

How to Add Multiple Data Columns To A Datatable At Once using ASP.NET2 min read

Leave a Comment X

You may also like

Leave a Comment X