How Is Possible Check Row Affected
-
Hows it is possible to tell when rows in SQL database have been updated by the update command? My page does need to know if the row is now renewed with the data, and how many rows was updated. Your help is needs must.
If you are using 2.0 look at SqlDependency or SqlCacheDependency
only two letters away from being an asset
-
I read this but it does not make clear to me.
-
If you are using 2.0 look at SqlDependency or SqlCacheDependency
only two letters away from being an asset
Perhaps i not make myself clear. I code the SqlConnection with Update command manually and update the record. Inot use any DataSet or others. When i run Update it update the informations. This is good. But how do i see how many rows records have been updated? Please your help for i read the dependencies infos but not mean anything to me. This is not right for my problem i think. Thank
-
Perhaps i not make myself clear. I code the SqlConnection with Update command manually and update the record. Inot use any DataSet or others. When i run Update it update the informations. This is good. But how do i see how many rows records have been updated? Please your help for i read the dependencies infos but not mean anything to me. This is not right for my problem i think. Thank
ExecuteNonQuery "For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command. For all other types of statements, the return value is -1."
only two letters away from being an asset
-
ExecuteNonQuery "For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command. For all other types of statements, the return value is -1."
only two letters away from being an asset
Many Thank For Answer. My question is how do i find this information to make us of please? I know not how i get this return value from Insert statement.
-
Many Thank For Answer. My question is how do i find this information to make us of please? I know not how i get this return value from Insert statement.
-
Is my question make angry? Sorry that my brain does not knows these things yet.
-
Hows it is possible to tell when rows in SQL database have been updated by the update command? My page does need to know if the row is now renewed with the data, and how many rows was updated. Your help is needs must.
-
I don't see a problem... I suppose you use SqlCommand to run your UPDATE statement, right? And SqlCommand.ExecuteNonQuery method returns you number of affected rows... Or do I not understand what you mean? Pilo
Yes, I do like this
SqlConnection6.ConnectionString = "connstring goes here"; string sql = "update string goes here"; SqlCommand cmd = new SqlCommand(sql, SqlConnection6); SqlConnection6.Open(); cmd.ExecuteNonQuery(); SqlConnection6.Close();So how from this must i get number of rows please? -
Yes, I do like this
SqlConnection6.ConnectionString = "connstring goes here"; string sql = "update string goes here"; SqlCommand cmd = new SqlCommand(sql, SqlConnection6); SqlConnection6.Open(); cmd.ExecuteNonQuery(); SqlConnection6.Close();So how from this must i get number of rows please?