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);
}
