To add 5 and half hours in a selected column of datatable
for (int i=0; i<dt.Rows.Count; i++)
{
string date1 = dt.Rows[i][5].ToString();
string [] date2 = date1.Split(' ');
string[] date3 = date2[1].Split(':');
int hr = Convert.ToInt32(date3[0]) + 5;
int mm = Convert.ToInt32(date3[1]);
string mm1 = string.Empty;
if (Convert.ToInt32(date3[1]) > 30)
{
hr = hr + 1;
mm = mm - 30;
mm1 = mm.ToString("00");
//mm = Convert.ToInt32(mm1);
}
else
{
mm1 = Convert.ToString((Convert.ToInt32(date3[1]) + 30));
}
string date4 = Convert.ToString(hr) + ":" + Convert.ToString(mm1) + ":" + Convert.ToString(date3[2]);
string date5 = date2[0] + " " + date4;
dt.Rows[i][5] = date5;
//dt2.Columns.Add("Created");
}
for (int i=0; i<dt.Rows.Count; i++)
{
string date1 = dt.Rows[i][5].ToString();
string [] date2 = date1.Split(' ');
string[] date3 = date2[1].Split(':');
int hr = Convert.ToInt32(date3[0]) + 5;
int mm = Convert.ToInt32(date3[1]);
string mm1 = string.Empty;
if (Convert.ToInt32(date3[1]) > 30)
{
hr = hr + 1;
mm = mm - 30;
mm1 = mm.ToString("00");
//mm = Convert.ToInt32(mm1);
}
else
{
mm1 = Convert.ToString((Convert.ToInt32(date3[1]) + 30));
}
string date4 = Convert.ToString(hr) + ":" + Convert.ToString(mm1) + ":" + Convert.ToString(date3[2]);
string date5 = date2[0] + " " + date4;
dt.Rows[i][5] = date5;
//dt2.Columns.Add("Created");
}