I got an error during fill in dataset when the sql statment return over 2000 records.
I don't know how to solve the problem??
I need to fill in dataset and export to excel.
If i use sql analzyer to select the data, it just use less than 1 minus.


dsExcelExport.Clear()
daExcelExport.SelectCommand = New SqlCommand
daExcelExport.SelectCommand.Connection =dtsclass.DatabaseConnection.GetDbConnection("ACCOUNT")
daExcelExport.SelectCommand.CommandText = "select invno,number,amount , xxx from invheader"
daExcelExport.Fill(dsExcelExport) <---