Web service method using update datebase in asp.net

how to use update query in web service开发者_运维技巧 wethod

Your web service method would call an update query just like any other method.

using(SqlConnection conn = new SqlConnection(connectionString))
{
    conn.Open();

    SqlCommand command = new SqlCommand("update field1 from Table where rowId = 7", conn);

    command.ExecuteNonQuery();
}