How to add another Columns to gridview through C# code?

chobo2 · #1 (**permalink**) March 8th, 2009, 06:46 PM

Hi

I using my sql to return back a dataset of columns however I need to add another column before I bind it to the gridview.

Basically I need one of the columns that is coming from the dataset what is a date field and find the difference between that date and the current date(todays date) and for each row add under a new column(say differenceColumn) the difference between each date.

I am not sure if I could do this write in one go or something with my sql statement if I can could I see an example of that?

I also would like to know how to add columns in C# code too.

gbianchi · #2 (**permalink**) March 8th, 2009, 07:36 PM

You could add this directly in you SQL query (how to do it depends on the database you are using). In fact I think this is faster, because if you want to add it at the code, you will have to loop everyrow adding the value.

The function in SQL server or access is datediff, I don't remember the oracle one. You would add a column to the select part with the function and the diference between actual day (how to obtain it also depends on the database) and the column you want. and name it like you want .

chobo2 · #3 (**permalink**) March 8th, 2009, 08:33 PM

Quote:

Originally Posted by gbianchi

You could add this directly in you SQL query (how to do it depends on the database you are using). In fact I think this is faster, because if you want to add it at the code, you will have to loop everyrow adding the value.

The function in SQL server or access is datediff, I don't remember the oracle one. You would add a column to the select part with the function and the diference between actual day (how to obtain it also depends on the database) and the column you want. and name it like you want .

I am using a mssql 2005 database. So could you right a small example of this?

Thanks

PeterPeiGuo · #4 (**permalink**) March 8th, 2009, 08:36 PM

The answer is yes, and select statement can return more than just the columns.

chobo2 · #5 (**permalink**) March 8th, 2009, 08:37 PM

Quote:

Originally Posted by PeterPeiGuo

The answer is yes, and select statement can return more than just the columns.

I am not sure what you mean by a "select statement can return more than just columns"

Can I see an example or tutorial of this?

I am not that great with databases so this is new to me.

PeterPeiGuo · #6 (**permalink**) March 8th, 2009, 08:44 PM

Quote:

Originally Posted by gbianchi

The function in SQL server or access is datediff

He might want timediff. datediff only gives the difference in days. Well, depend on his requirement, which he didn't clearly specify.

chobo2 · #7 (**permalink**) March 8th, 2009, 08:45 PM

Quote:

Originally Posted by PeterPeiGuo

He might want timediff. datediff only gives the difference in days. Well, depend on his requirement, which he didn't clearly specify.

I just want the different in days. I actually need a way to remove the time part. Like it is a TimeDate but I really only want the Date not the Time but they don't have an option that just shows Date.

PeterPeiGuo · #8 (**permalink**) March 8th, 2009, 08:45 PM

For example:

Code:

SELECT TIMEDIFF('2000:01:01 00:00:00', '2000:01:01 00:00:00.000001');

chobo2 · #9 (**permalink**) March 8th, 2009, 08:57 PM

Quote:

Originally Posted by PeterPeiGuo

For example:

Code:

SELECT TIMEDIFF('2000:01:01 00:00:00', '2000:01:01 00:00:00.000001');

How would I mix that with other statements. Like I am grabbing other table columns

this is what I have

Code:

SELECT  Planner.CourseName, Planner.Type, Planner.Description, Planner.DueDate, Planner.Weight, PlannerSettings.CourseColor, 
                      PlannerSettings.FontColor 
FROM         Planner INNER JOIN
                      PlannerSettings ON Planner.ID = PlannerSettings.ID
WHERE     (Planner.UserID = @UserID) AND (Planner.UserName = @UserName) AND (Planner.NotifcationDate <= @date)

I tried to add what you had after my stuff but I just get errors. I used datediff though not timediff

PeterPeiGuo · #10 (**permalink**) March 8th, 2009, 09:32 PM

Quote:

Originally Posted by chobo2

I really only want the Date not the Time but they don't have an option that just shows Date.

Of course they do. For example

Code:

SELECT DATE('2003-12-31 01:02:03');

Need to download code?

Navigation