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;
}
Replies
Know the answer? Post it — somebody with the same question will find it here.