Get data from page load event and display on gridview in ASP.NET

Question

0.00/5 (No votes)

See more:

Hello,

I am storing some data into a variable at Page Load event. And I have a gridview in the same page which is getting data from SQL database. What i want is to also add another column in the gridview and populate it with the value in the variable from Page Load event.
Is there any way for this? I want to do this because i am calculating something which will be changed with respect to change in date, so therefore i want to fetch data from page load and populate the gridview with it.

What I have tried:

Searched google and other forums but could not find anything related to this.

Posted 6-Oct-16 7:01am

Faran Saleem

Updated 7-Oct-16 11:38am

Add a Solution

Comments

ZurdoDev 6-Oct-16 14:04pm

Search for how to dynamically add a column to gridview.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Vincent Maverick Durano · Answer 1 · 2016-10-06T23:35:00

A data representation control like GridView can only handle one DataSource at a time. Since your data is coming from different sources (database and code variable), then you may need create a custom DataTable that would holds all the information you need from your sources. You could then use that custom DataTable as your final DataSource for your GridView.

Here's a quick example: (PS: Never tested on this, but it should give you some idea)

C#

private void BindGrid(DataDaTable source)
{
        //create your final datasource
        DataTable dt = new DataTable();
        DataRow dr;

        //define new sets of columns that you need
        dt.Columns.Add(new System.Data.DataColumn("Column1", typeof(String)));
        dt.Columns.Add(new System.Data.DataColumn("Column2", typeof(String)));
        dt.Columns.Add(new System.Data.DataColumn("Column3", typeof(String)));
 
        //you can add more columns here if needed

        //fill your new DataTable with data from your sources
        int rowCount = source.Rows.Count;
	if ( rowCount > 0){
            for(int i=0; i < rowCount; i++){
            dr = dt.NewRow();
            dr[0] = source.Rows[i]["ColumnName"].ToString();
            dr[1] = source.Rows[i]["ColumnName"].ToString();
	    dr[2] = "Your custom variable value here";
            dt.Rows.Add(dr);
            }
        }
 
	GridView1.DataSource = dt;
        GridView1.DataBind();
}

Alternatively, you could just add a new Column to your existing DataTable something like:

C#

DataColumn newColumn = new DataColumn("ColumnName", typeof(System.String));
newColumn.DefaultValue = "Your variable value";
dt.Columns.Add(newColumn);

manu_dhobale · Answer 2 · 2016-10-07T11:38:00

I have tried below

C#

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace WebApplication1
{
    public partial class WebForm3 : System.Web.UI.Page
    {
        string customColumn = string.Empty;
        protected void Page_Load(object sender, EventArgs e)
        {
            customColumn = "INDIA";
        }
        protected void Button1_Click(object sender, EventArgs e)
        {
            DataTable table = new DataTable();
            table.Columns.Add("Dosage", typeof(int));
            table.Columns.Add("Drug", typeof(string));
            table.Columns.Add("Patient", typeof(string));
            table.Columns.Add("Date", typeof(DateTime));

            // Here we add five DataRows.
            table.Rows.Add(25, "Indocin", "David", DateTime.Now);
            table.Rows.Add(50, "Enebrel", "Sam", DateTime.Now);
            table.Rows.Add(10, "Hydralazine", "Christoff", DateTime.Now);
            table.Rows.Add(21, "Combivent", "Janet", DateTime.Now);
            table.Rows.Add(100, "Dilantin", "Melanie", DateTime.Now);


            //Add new column  in gridview if its not set true for autogenerare columns
            //BoundField test = new BoundField();
            //test.DataField = "Country";
            //test.HeaderText = "Country";
            //GridView1.Columns.Add(test);


            //add  new column for your custom variable to datasource
            table.Columns.Add(new DataColumn("Country"));


            GridView1.DataSource = table;
            GridView1.DataBind();

        }

        protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                //putting data in column Conditionaly 
                if (Convert.ToDateTime(e.Row.Cells[3].Text)<DateTime.Now)
                {
                    e.Row.Cells[4].Text = customColumn;
                }
            }
        }
    }
}

Get data from page load event and display on gridview in ASP.NET

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0