Updating is not supported by data source sqldatasource1 unless updatecommand

09-Nov-2019 00:52

You can handle these events to determine whether an exception was thrown during the database operation, to learn how many records were affected by the operation, or to examine any output values the database operation returns.

For example, the following code example uses the control can perform update and delete operations using optimistic concurrency.

Click Dim connetion String As String Dim connection As Ole Db Connection Dim oledb Adapter As New Ole Db Data Adapter Dim sql As String connetion String = "Provider=Microsoft. OLEDB.4.0; Data Source=Your mdb filename;" connection = New Ole Db Connection(connetion String) sql = "update Users set Password = 'new password' where User ID = 'user1'" Try connection.

Check these two out: Connecting to a Local SQL Server Express Instance: I tried again the two strings , but still the error says: A network-related or instance-specific error occurred while establishing a connection to SQL Server.

Inserting is not supported by data source ' Sql Data Source2' unless Insert Command is specified.