The Journey

Below is a useful snipit of code, it sets the timeout for DataSource controls. Replace SqlDataSource with the ID of the datasource. Protected Sub SqlDataSource_Selecting(sender As Object, e As System.Web.UI.WebControls.SqlDataSourceSelectingEventArgs) Handles SqlDataSource.Selecting e.Command.CommandTimeout = 1000 End Sub

Found this very useful CSV file splitter for files over 65536 rows (excel before 2007) or 1048576 rows (excel 2007+). See the original forum thread here or download here