DataAccess.cs

                Never    
C#
       
using System;
using RJK.Framework;
using System.Data.SqlClient;

namespace Ucar.Ucar.DataAccess.W14
{
    [DataAccess(@"SKFCdbConnection")]
    public class UserMasterDataAccess : BaseDataAccess
    {

        public SqlDataReader GetUserMasterList(String tableName)
        {
            var sql = @"
                UPDATE {TableName}

                SET Password = 'new_password'

                WHERE
                    {tbsm_Users} WITH (NOLOCK) ";

            return DBSelect(sql.Replace("{tableName}", tableName), null, 1);
        }
    }
}

Raw Text