C# (CSharp) DAL SQLiteHelper.GetSingleResult Exemples

Exemple #1

        public object  GetCount()
        {
            string sql = "SELECT COUNT(*) FROM SetInfo";

            return(SQLiteHelper.GetSingleResult(sql));
        }

Exemple #2

Fichier : PatientService.cs Projet : kliein/Hospital10-11-WIN7-WIN10

        public int  SelectIsNo(int bendnum)
        {
            string sql = "select count(*) from  Patients where PatientBednum=" + bendnum.ToString() + " and UseFlag=0";

            return(Convert.ToInt32(SQLiteHelper.GetSingleResult(sql)));
        }