datagridview how to show values which is not in database

Question

1.00/5 (1 vote)

See more:

.NET3.5

Hi i have 5 Columns pfno, passno, relation,status,here want to display age ,dob

Now i want to display age of person between status and dob according to dob.
But i do not want to store age in database i want to show it dynamically.

suppose dob is 19/10/1992

then in age i want to display 20 years 2 mothns 1 day something like this i want

please help

Posted 28-Aug-12 1:25am

Anurag Sarkar

Updated 28-Aug-12 1:27am

v2

Add a Solution

Comments

[no name] 28-Aug-12 7:41am

I have all the values in database except age

[no name] 28-Aug-12 7:41am

I only want age to be added at runtime

3 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)

Sarrrva · Accepted Answer · 2012-08-28T01:34:00

Solution 1

you can use data table for this issue,

public DataTable Sel()
        {
            DataTable dt = new DataTable();
            try
            {
                Con_Open();
                cmd = new SqlCommand("select * from Stu", con);
                dr = cmd.ExecuteReader();
                if (dr.HasRows)
                {
                    dt.Columns.Add(new DataColumn("Reg No"));
                    dt.Columns.Add(new DataColumn("Name"));
                    dt.Columns.Add(new DataColumn("Mark1"));
                    dt.Columns.Add(new DataColumn("Mark2"));
                    dt.Columns.Add(new DataColumn("Mark3"));
                    while (dr.Read())
                    {
                        DataRow temp;
                        temp = dt.NewRow();
                        temp[0] = (System.Convert.IsDBNull(dr[0]) ? "" : dr[0].ToString());
                        temp[1] = (System.Convert.IsDBNull(dr[1]) ? "" : dr[1].ToString());
                        temp[2] = (System.Convert.IsDBNull(dr[2]) ? "" : dr[2].ToString());
                        temp[3] = (System.Convert.IsDBNull(dr[3]) ? "" : dr[3].ToString());
                        temp[4] = (System.Convert.IsDBNull(dr[4]) ? "" : dr[4].ToString());
                        dt.Rows.Add(temp);
                    }
                    cmd.Dispose();
                    dr.Close();
                    con.Close();
                }
                else
                {

                    dt.Columns.Add(new DataColumn("Records"));
                    DataRow temp;
                    temp = dt.NewRow();
                    temp[0] = "No Records Found!!";
                    dt.Rows.Add(temp);
                }
                return dt;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message.ToString());
                if (con.State == ConnectionState.Open)
                {
                    con.Close();
                }
                if (!dr.IsClosed)
                {
                    dr.Close();
                }
                return null;
            }
        }

Call:

C#

Griview1.DataSource=Sel();

regards
sarva

Posted 28-Aug-12 1:34am

Sarrrva

Comments

[no name] 28-Aug-12 7:40am

Can u please explain it to me a bit

[no name] 28-Aug-12 7:40am

in this which data is coming from database and which is auto gen?

Sarrrva 28-Aug-12 7:56am

Actually Whats Your Need? Send Your Full Code... Onurag
regards
sarva

Sarrrva 28-Aug-12 8:03am

public DataTable Sel()
{
DataTable dt = new DataTable();
try
{
Con_Open();
cmd = new SqlCommand("select * from YourTable", con);
dr = cmd.ExecuteReader();
if (dr.HasRows)
{
dt.Columns.Add(new DataColumn("Pfno"));
dt.Columns.Add(new DataColumn("passno"));
dt.Columns.Add(new DataColumn("relation"));
dt.Columns.Add(new DataColumn("Age")); // Non Database column
dt.Columns.Add(new DataColumn("Dob"));
dt.Columns.Add(new DataColumn("Status"));
while (dr.Read())
{
DataRow temp;
temp = dt.NewRow();
temp[0] = (System.Convert.IsDBNull(dr[0]) ? "" : dr[0].ToString());
temp[1] = (System.Convert.IsDBNull(dr[1]) ? "" : dr[1].ToString());
temp[2] = (System.Convert.IsDBNull(dr[2]) ? "" : dr[2].ToString());
temp[3] = Some C#.net Statement; // Do Something Here for Your Age Calculation
temp[4] = (System.Convert.IsDBNull(dr[4]) ? "" : dr[4].ToString());
temp[5] = (System.Convert.IsDBNull(dr[5]) ? "" : dr[5].ToString());
dt.Rows.Add(temp);
}
cmd.Dispose();
dr.Close();
con.Close();
}
else
{

dt.Columns.Add(new DataColumn("Records"));
DataRow temp;
temp = dt.NewRow();
temp[0] = "No Records Found!!";
dt.Rows.Add(temp);
}
return dt;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
if (con.State == ConnectionState.Open)
{
con.Close();
}
if (!dr.IsClosed)
{
dr.Close();
}
return null;
}
}

regards
sarva

[no name] 28-Aug-12 8:17am

public void getgridview()
{
//MySqlDataAdapter da;

try
{
string constr = @"server=localhost;uid=root;password=password;database=passdb";
MySqlConnection con = new MySqlConnection(constr);
con.Open();
string str = "select * from empdependents where pfno = '" + textBox1.Text + "'";
ds = new DataSet();
MySqlDataAdapter da = new MySqlDataAdapter(str, con);
DataSet ds1 = new DataSet();
da.Fill(ds1, "empdependents");
DataGridView age=new DataGridView();
dataGridView3.Rows.Insert(dataGridView3.Rows.Count -1,age );
this.dataGridView3.DataSource = ds1.Tables[0];
con.Close();

}
catch (Exception ex)
{
MessageBox.Show("Check Data" + ex.Message);
}
}

[no name] 28-Aug-12 8:18am

i have selected all the values from database and now i want to add row in it

Sarrrva 28-Aug-12 8:21am

Where is Your Field Details?

Sarrrva 28-Aug-12 8:23am

Look My 2nd Reply onurag... Answer is there...
Temp[3]= Some C#.net Statement; // Do Something Here for Your Age Calculation
regards
sarva

[no name] 28-Aug-12 8:26am

i have selected all the field by putting *

Sarrrva 28-Aug-12 8:43am

try something like this friend
DataSet ds = (DataSet)GV.DataSource;

DataRow dr = ds.Tables[0].NewRow();
ds.Tables[0].Rows.Add(dr);

GV.DataSource = ds;
GV.DataBind();

[no name] 28-Aug-12 13:03pm

its giving error object reference not set to an instance of object

sjelen · Accepted Answer · 2012-08-28T01:53:00

Solution 2

You can calculate Age in your select statement (pretty easy in SQL or in LINQ, whichever you use)
If dob is DateTime:

SQL

SELECT pfno, passno, relation, status, DATEDIFF(year, dob, getdate()) as age, dob

If it's not datetime, you'll need to convert it.

Posted 28-Aug-12 1:53am

sjelen

Updated 28-Aug-12 1:56am

v2

Comments

[no name] 28-Aug-12 13:52pm

What is getdate() here?

sjelen 30-Aug-12 6:32am

getdate() is MS SQL function that returns current date and time, same as DateTime.Now in C#.
This will calculate age as years, if you need "year, month, day" take a closer look at DATEDIFF function.
It can calculate date difference in many ways.

[no name] 28-Aug-12 14:03pm

Thanks a Lot

bhagirathimfs · Accepted Answer · 2012-08-28T01:59:00

Solution 3

Inside the Itemdatabound Event of the datagrid (In Gridview RowDataBound event)
calculate the age like DOB - Today and store in the age column no need.

For more reference Click Here[^]

Posted 28-Aug-12 1:59am

bhagirathimfs