Hi,

I have 50 rows of data in Datagridview. My app will read all rows line by line then save it in DB.

When I click the "Save" button my apps entering into not responding mode after sometime it has come back to normal state.

Please suggest me to avoid this scenario.(Without Threading Concept)

Thanks in Advane.

Recommended Answers

Reduce how many rows you save in a single call and call save repeatedly. Although this won't really change anything, you're still not going to be able to do anything while the rows get saved and this might take longer.

It is impossible to do without threading.

Jump to Post

All 3 Replies

How big are your rows and what code do you use to save to the DB?

Reduce how many rows you save in a single call and call save repeatedly. Although this won't really change anything, you're still not going to be able to do anything while the rows get saved and this might take longer.

It is impossible to do without threading.

Why would you not use threading?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.