The no. of rows returned in my DataTable is only two rows(always), do i need to use looping structure for the same, without it isn't it possible...Find the code snipet of the same.
objTSPeriodTable - Table has two rows - which gives the month from date(starting date), to date( the end date, depending on the fortnight).
foreach(DataRow drPeriod in objTSPeriodTable.Rows )
{
objSQLParam[0] =
new SqlParameter("@timeSheetPeriodFrom",drPeriod[0].ToString());
objSQLParam[1] =
new SqlParameter("@timeSheetPeriodTo",drPeriod[1].ToString());
break;
}