如何从C#中的数据库中选择并遍历多个行?

我想从SQLServer数据库中选择许多行,并以某种方式组合它们。目前,我一直在使用以下方法获取这些行:

SqlDataSource mySource = new SqlDataSource("ConnectionString","SelectStatement");
IEnumerable myEnum = mySource.Select(DataSourceSelectArguments.Empty);
IEnumerator myCount = myEnum.GetEnumerator();
while(myCount.MoveNext()) //Iterate through each row
{
    DataRowView myView = (DataRowView)myCount.Current; //This is the current row
    //Do something with this row
}

我觉得一定有更好的办法。有什么建议吗?