Accessing Data from Data table using for loop
<p>I want to get data from data table using for loop. i tried as belows but not working. please help me</p>

<pre><code>String GetBelowDataWeekly = "Select EmployeeID from v_Et_EmployeeProfile where DivisionName=N'" + DivisionName + "' COLLATE Latin1_General_100_CI_AS and PositionName=N'Officer'COLLATE Latin1_General_100_CI_AS union all Select EmployeeID from v_Et_EmployeeProfile where DivisionName=N'" + DivisionName + "' COLLATE Latin1_General_100_CI_AS and DepartmentName= N'None' COLLATE Latin1_General_100_CI_AS";
SqlDataAdapter adaptGetBelowDataWeekly = new SqlDataAdapter(GetBelowDataWeekly, DBcon.con);
DataTable dtGetBelowDataWeekly = new DataTable();
adaptGetBelowDataWeekly.Fill(dtGetBelowDataWeekly);
for (int i = 0; i &lt; dtGetBelowDataWeekly.Rows.Count; i++)
{
    Response.write(dtGetBelowDataWeekly.Rows[i]);
}
</code></pre>