DataRow

Aug 7 2006 8:57 AM

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;

}