C# (CSharp) clsDataAccess.ExecuteScalar Examples

Example #1

File: OPDPatientMasterBLL.cs Project: CbrainSolutions/HMS

        public decimal GetRate(string pstrChangeDescruption)
        {
            decimal ldc = 0.0M;

            try
            {
                ldc = Commons.ConvertToDecimal(mobjDataAcces.ExecuteScalar("Select  Rate  From tblChargeMaster Where  ChargeDescription = '" + pstrChangeDescruption + "'"));
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(ldc);
        }