A simple synthesis of phenyl butenoyl C-glycosides has been achieved by Aldol condensation of peracetylated glycosyl acetones with aromatic aldehydes followed by deacetylation with methanolic NaOMe. The selected butenoyl C-glycosides on conjugate addition of diethyl malonate resulted in polyfunctional alkanonyl glycosides in good yields. The butenoyl C- and alkanoyl C-glycosides were evaluated for their alpha-glucosidase, glucose-6-phosphatse and glycogen phosphorylase enzyme inhibitory activities in vitro. Three of the synthesized (3, 5 and 9) showed potent enzyme inhibitory activities as compared to standard drugs. Compounds 3, 5 and 9 were evaluated in vivo too displaying significant activity as compared to standard drugs acarbose and metformin.