public void GetDataTableTestWithCondition() { DataConfiguration dataConfiguration = new DataConfiguration(); dataConfiguration.ReadConfiguration(); string query = @"SELECT a.nib FROM so_pos a WHERE a.pos_d > {5/11/14}"; string query2 = @"SELECT a.nib, a.pac_born, a.pacfam, a.pacname, a.pacsurname, a.pac_sex, a.pos_kno, a.out_kno, a.citycount, a.m_kres, a.pos_t, a.pos_d, a.out_d, a.out_t, a.withmother FROM so_otd b, so_pos a WHERE a.nib = b.nib AND a.pos_d >= {4/1/14} AND a.out_d <= {1/11/15}"; var queryTable = sqlDataHelper.DoQuery(dataConfiguration.Path, query2); Assert.IsTrue(queryTable.Rows.Count > 0); Console.WriteLine("Count = {0}", queryTable.Rows.Count); /* foreach (DataRow dataRow in queryTable.Rows) * { * foreach (var item in dataRow.ItemArray) * { * Console.WriteLine(item); * } * } */ }