HOW TO COMPARE DATE

ancy chacko

i am displayed date without using db...using this code

DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[1] { new DataColumn("Datess") });
ViewState["Customers"] = dt;
DateTime startDate = new DateTime(2015, 1, 26);
DateTime stopDate = new DateTime(2015, 2, 28);
int interval = 1;

for (DateTime dateTime = startDate; dateTime < stopDate; dateTime += TimeSpan.FromDays(interval))
{
dt.Rows.Add(startDate);
startDate = startDate.AddDays(interval);
ViewState["Customers"] = dt;
}
GridView1.DataSource = (DataTable)ViewState["Customers"];
GridView1.DataBind();
o/p is like this....
date
26/1/2015
..
....
27/2/2015
then i want to compare these date with my database table DATE
my database is
date 42 43 47 78
29/1/2015 p p A P
2/2/2015 A P P A
i want to compare these two date and display like this
date 42 43 47 78
26/1/2015
27/1/2015
28/1/2015
29/1/2015 p p A P
30/1/2015
31/1/2015
2/2/2015 A P P A
.....
...
27/2/2015

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes11y ago
Well, what I've tried to do with that code is to get all the records from the database with a date column between 'start' (inclusive) and 'end' (exclusive).

For each of these records I've then checked whether the DataTable already has a row for that date and, if it has, added the other 4 columns to that row.

If you were using an interval of more than one, then it's possible that would be no match between the two.

What I've described above seemed to me to be what you asked for in your opening post but, if it isn't, can you clarify what it is you do need.
ancy chacko11y ago
thank you for your reply...but iwant to compare startdate and my database date
Vulpes11y ago
If you're using SQL Server, the combined code to do all that is going to be something like this:

DataTable dt = new DataTable();

dt.Columns.AddRange(new DataColumn[5]
{
new DataColumn("Date", typeof(DateTime)),
new DataColumn("42"),
new DataColumn("43"),
new DataColumn("47"),
new DataColumn("78")
});

DateTime startDate = new DateTime(2015, 1, 26);
DateTime stopDate = new DateTime(2015, 2, 28);
int interval = 1;

for (DateTime dateTime = startDate; dateTime < stopDate; dateTime += TimeSpan.FromDays(interval))
{
dt.Rows.Add(startDate, "", "", "", "");
startDate = startDate.AddDays(interval);
}

using (SqlConnection conn = new SqlConnection(connectionString))
{
string query = "SELECT * FROM Customers WHERE [Date] >= @start && [Date] < @stop";
SqlCommand cmd = new SqlCommand(query, conn);
cmd.Parameters.Add("@start", SqlDbType.DateTime).Value = startDate;
cmd.Parameters.Add("@stop", SqlDbType.DateTime).Value = stopDate;
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();

while(reader.Read())
{
DateTime date1 = DateTime.Parse(reader[0].ToString());
foreach(DataRow dr in dt.Rows)
{
DateTime date2 = (DateTime)dr[0];
if (date1 == date2)
{
dr[1] = reader[1];
dr[2] = reader[2];
dr[3] = reader[3];
dr[4] = reader[4];
break;
}
}
}

reader.Close();
}

ViewState["Customers"] = dt;
GridView1.DataSource = (DataTable)ViewState["Customers"];
GridView1.DataBind();