Question

2
Replies
154
Views
Yukihito Yamamura (Yukihito)
Power Solutions, Ltd.

Power Solutions, Ltd.
JP
Yukihito Member since 2017 16 posts
Power Solutions, Ltd.
Posted: August 10, 2017
Last activity: November 6, 2018
Posted: 10 Aug 2017 4:49 EDT
Last activity: 6 Nov 2018 20:02 EST
Closed

How to update database with records in DataGridView

Hi,


Could anyone tell me about how to update database with records in DataGridView? I'm trying as follows but not sure which blocks should be after btnUpdate.Click event.




I also tried to use sqlAdapter.Update method. It requires database file but can't select a file because which is used by SQL Server. Like sqlQuery, which has a server and database name in ConnectionString property, is it possible for sqlAdapter to connect via database, not referring a database file?

Show More

Hi,

Could anyone tell me about how to update database with records in DataGridView? I'm trying as follows but not sure which blocks should be after btnUpdate.Click event.

I also tried to use sqlAdapter.Update method. It requires database file but can't select a file because which is used by SQL Server. Like sqlQuery, which has a server and database name in ConnectionString property, is it possible for sqlAdapter to connect via database, not referring a database file?

thanks,

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Show Less
Robotic Process Automation
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.