ASP.Net Grid Help....Date Comparison Issues.

Question

0.00/5 (No votes)

See more:

Hi Friends,

I am trying to add a column which displays Yes Or No Text based on column values if the previous 2 columns(Date Columns) difference is more than 1 month to Starting Date.

The Previous 2 columns are Start Date and End Date and the values of these 2 columns are coming from database. Please let me know if you need more information

Here is the code I am adding..

C#

Protected Sub GridView1_OnRowDataBound(ByVal sender As Object, ByVal e As GridViewRowEventArgs)

    If e.Row.RowType = DataControlRowType.DataRow Then
        Dim dtDOJ As DateTime = Convert.ToDateTime(e.Row.Cells(4).Text)
        Dim dtDOJ1 As DateTime = Convert.ToDateTime(e.Row.Cells(5).Text)
        
        If dtDOJ1 >= dtDOJ.AddMonths(1) Then
            e.Row.Cells(6).Text = "Yes";
        Else
            e.Row.Cells(6).Text = "No";
        End If
    End If


End Sub

Posted 5-Jun-13 20:29pm

Member 9861478

Updated 5-Jun-13 20:59pm

v7

Add a Solution

Comments

Abhinav S 6-Jun-13 2:55am

Are you facing some issues with this code? Is it not working?

Thanks7872 6-Jun-13 2:58am

You have not mentioned what the issue is. Well,i think you faced issue in finding the values of cells right? And where have you taken this yes/no values?dropdown,textbox,label?

Member 9861478 6-Jun-13 3:03am

Oops! Thank you for probing. I haven't added any textbox or label. Really new to use grid and I am in a migration project..Could you please guide me on this?

Member 9861478 6-Jun-13 3:10am

I searched in google and found to add Label..May that helps for next steps sorry abt that...

Member 9861478 6-Jun-13 2:58am

Yes Abhinav. The code is not working..seems no error but no result.

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)

Thanks7872 · Answer 1 · 2013-06-05T21:11:00

Solution 2

Have a look at below code(Though its in C#,use converter for VB):

C#

<asp:gridview id="GridView1" runat="server" onrowdatabound="GridView1_RowDataBound" xmlns:asp="#unknown">
    <columns>
        <asp:templatefield>
            <itemtemplate>
               <asp:label id="lbl" runat="server" text=""></asp:label>
            </itemtemplate>
        </asp:templatefield>
    </columns>
</asp:gridview>

The event you used is ok.

C#

protected void lr_grid_RowDataBound(object sender, GridViewRowEventArgs e)
       {
           if (e.Row.RowType == DataControlRowType.DataRow)
           {
                //Do your calculations and then assign text to lbl(that is label in templatefield)
           }
       }

For date calculations use DateTime.Compare Method[^]

Happy coding.. :)

Posted 5-Jun-13 21:11pm

Thanks7872

Updated 5-Jun-13 23:40pm

v3

Comments

Member 9861478 6-Jun-13 3:14am

Thank you . I will try and let you know....Really appreciated.

Member 9861478 6-Jun-13 3:47am

Surprisingly, The label id is not getting inherited in code behind..any idea?

Thanks7872 6-Jun-13 3:49am

It will not because its a template field.Access it as below

Label lbl_temp = (Label)e.Row.FindControl("lbl");
lbl.Text = your values;

Thanks7872 6-Jun-13 3:50am

This code will create one label and then the value will be assigned to that label which ultimately shown in gridview.

Member 9861478 6-Jun-13 3:53am

Thanks. Sorry for my ignorance..I am trying that..Really helpful..

Member 9861478 6-Jun-13 4:02am

Thank you for your motivation. I don't forget this..

Member 9861478 6-Jun-13 3:59am

Just have a doubt on my assumption...

Is this below way to identify a column and assign it to a variable

Dim dtDOJ As DateTime = Convert.ToDateTime(e.Row.Cells(5).Text)

I assume the description of the step is:
I declared a date variable and assigned it with fifth column which is date column in my project..Please correct me if i am wrong..

Thanks7872 6-Jun-13 4:39am

yes theres no issue with this one.but if you want to assign value at run time(in rowdatabound event) then use templatefield with label,otherwise take a bound field and fill the gridview.For the remaining fields(templatefield),do as i suggested before.

Member 9861478 6-Jun-13 4:44am

THANK YOU......

Thanks7872 6-Jun-13 4:43am

Forget to mention that if you want to access fifth column then you will use cells[4],not 5,because index starts with 0.

Member 9861478 6-Jun-13 4:45am

Okay..Marked it..

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 2 · 2013-06-05T20:57:00

Use [MSDN] DateTime.Compare Method[^].

Quote:
Compares two instances of DateTime and returns an integer that indicates whether the first instance is earlier than, the same as, or later than the second instance.

Parameters
t1
Type: System.DateTime
The first object to compare.
t2
Type: System.DateTime
The second object to compare.

Return Value
Type: System.Int32
A signed number indicating the relative values of t1 and t2.
Value Type            Condition
Less than zero        t1 is earlier than t2.
Zero                  t1 is the same as t2.
Greater than zero     t1 is later than t2.