I've got DataGridView named gradesDGV with datasource based on BindingSource which datasource is DataSet.
In DataSet I've tableAdapter created from stored procedure. (MS SQL 2005)
I have choose apropriate stored procedure for Select and Update. (It's really simply and finds record to update based only on primarry key)
Everything is working I can view all grades and I can edit them.
But problem is when I have for example 200 records to update. CPU is up to 100% for about 10 minutes and computers aren't so slow.
How can I improve the performance?
And why it's taking so long to update 200 records?
If you need any other information just ask.
Thanks in advance.