Um.
I think you are mistaken:
using (SqlConnection con = new SqlConnection(strConnect))
{
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter("SELECT TOP 100 Title from Videos", con);
da.Fill(dt);
Console.WriteLine("{0}:{1}", dt.Columns.Count, dt.Rows.Count);
dt.Columns.Clear();
Console.WriteLine("{0}:{1}", dt.Columns.Count, dt.Rows.Count);
}
Gives:
1:100
0:100
So start by looking at your code, and see exactly what you are doing, and what you are trying to achieve.