public CLigneTableParametrable[] SelectRows(string strRequete) { DataRow[] rows = DataTableObject.Select(strRequete); List <CLigneTableParametrable> result = new List <CLigneTableParametrable>(); foreach (DataRow r in rows) { result.Add(r); } return(result.ToArray()); //return null; }
public int[] GetIndexOfRowsContains(string strColumnName, string strRecherche) { if (!DataTableObject.Columns.Contains(strColumnName)) { return(new int[0]); } List <int> listeIndexes = new List <int>(); DataRow[] resultRows = DataTableObject.Select(strColumnName + "= '" + strRecherche + "'"); foreach (DataRow row in resultRows) { listeIndexes.Add(DataTableObject.Rows.IndexOf(row)); } return(listeIndexes.ToArray()); }
public int GetFirstNotUsedValue(string strColumnName, int nValMin, int nValMax) { if (!DataTableObject.Columns.Contains(strColumnName)) { return(nValMin - 2); } for (int n = nValMin; n <= nValMax; n++) { DataRow[] rows = DataTableObject.Select(strColumnName + "=" + n.ToString()); if (rows.Length == 0) { return(n); } } return(nValMin - 1); }