SELECT SUM(CASE WHEN [Column1] = 'jin' THEN 1 ELSE 0 END + CASE WHEN [Column2] = 'jin' THEN 1 ELSE 0 END + CASE WHEN [Column3] = 'jin' THEN 1 ELSE 0 END) AS COUNTS FROM Time
Gentle db = new Gentle(); Time ec = new Time(); for (int i = 0; i < 4; i++) { if (ec.Column1 == "jin") { counts= counts + 1; } }
int count = dt.Select().Where(s => s["Column1"].ToString().ToLower() == "jin").Count();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)