從datasource 產生datatable 並刪除不要的資料

DataView view = (DataView)SqlDataSource1.Select(new DataSourceSelectArguments());

DataTable dt = view.ToTable();

for (int i = dt.Rows.Count - 1; i >= 0; i--)

{

DataRow dr = dt.Rows[i];

if (...) dr.Delete();

}

dt.AcceptChanges();