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?
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.
Pegasystems Inc.
US
You need to use the SQLComponents to perform a Database update. You'd need to know how to setup your database connection first. Do you have the database connectivity information?