Hi Amigos!

I am trying to update a record with the following code:

Dim UsersUpdateCmd As New SqlClient.SqlCommand
UsersUpdateCmd.Connection = cn
UsersUpdateCmd.CommandType = CommandType.StoredProcedure
UsersUpdateCmd.CommandText = "UpdateUser"

UsersUpdateCmd.Parameters.Add("@UserID", SqlDbType.VarChar, 10, "UserID")
UsersUpdateCmd.Parameters.Add("@UserName", SqlDbType.VarChar, 20, "UserName")
UsersUpdateCmd.Parameters.Add("@Password", SqlDbType.VarChar, 20, "Password")

daUsers.UpdateCommand = UsersUpdateCmd

Dim EditRow As Data.DataRow = dtUsers.Rows(dtUsers.Rows.Count - 1)

EditRow.BeginEdit()

When any of the following lines are executed, I get an error message saying that they are ReadOnly.

EditRow("UserID") = "005"
EditRow("UserName") = "Odie"
EditRow("Password") = "456"

Any ideas as to why this is so? I've been at this since yesterday. Please HELP!!!

By the way, I have similar routines for adding and deleting records and I do not have any problems. It is only when I try to modify a record that I encounter problems.

Desparately yours,

Martin