Esempi in C# (CSharp) per DAL SQLiteHelper.GetSingleResult

Esempio n. 1

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

            return(SQLiteHelper.GetSingleResult(sql));
        }

Esempio n. 2

File: PatientService.cs Progetto: 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)));
        }