Bad performance on datagrid update.

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.
Best Regards
LVL 11
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

f o o k y,

Could you post the code for your Stored Procedure?


f_o_o_k_yAuthor Commented:
I solved it sorry for bothering you.

Problem was that other column had property
AutoSizeMode = AllCells
I really don't know why. :D

Best Regards

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.