>StringBuilder sb = new StringBuilder(); >sb.Append("SELECT *"); >sb.AppendFormat(" FROM {0}",YourTableName); >sb.AppendFormat(" WHERE cName LIKE '{0}%'", WorkGroup); >sb.AppendFormat(" AND dIntervalStart >= '{0}' AND dIntervalStart < '{1}'", StartDate, EndDate); >sb.Append(" GROUP BY cName"); >string sql = sb.ToString(); > >SqlConnection cn = new SqlConnection(SqlDataSource); >SqlCommand cm = new SqlCommand(sql, cn); >