How to update database with records in DataGridView
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?
**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.