Bad performance on datagrid update.

Hello,
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
FooKy
LVL 11
f_o_o_k_yAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
f_o_o_k_yConnect With a Mentor Author Commented:
Ok.
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
FooKy
0
 
jake072Commented:
f o o k y,

Could you post the code for your Stored Procedure?

Thanks,

Jake
0
All Courses

From novice to tech pro — start learning today.