C#

Som Shekhar wrote:

assigning it to a view and change row filter?

DataView view = table.DefaultView;
view.RowFilter = "Value>2";

DataTable table = new DataTable();
table.Columns.Add(columnName);

for (int i = 0; i < 1000000; i++)
{
    table.Rows.Add(i);
}
MessageBox.Show("Loaded", "");


//---------------------------------------------------
string condition = columnName + ">500 AND " + columnName + "<10000";
DateTime timeStart = DateTime.Now;
DataView view = table.DefaultView;
view.RowFilter = condition;
DataTable newTable = view.ToTable();
DateTime timeStop = DateTime.Now;

TimeSpan span = timeStop - timeStart;
MessageBox.Show(span.TotalMilliseconds.ToString(), "");
//---------------------------------------------------
timeStart = DateTime.Now;
DataRow[] rows = table.Select(condition);
timeStop = DateTime.Now;
span = timeStop - timeStart;
MessageBox.Show(span.TotalMilliseconds.ToString(), "");

Dave Kreskowiak wrote:

just return the rows you need

combobox.items.insert("","")

private static List<T> CreateList<T>(List<T> data) 
        {
            //create new generic item (blank)

             
             List<T> list = new List<T>();
            // list.Add(); add new generic item here
             list.AddRange(data);

            return list;
        }

public struct MyWrapper<T>
{
  public MyWrapper(T value)
  {
    _value = value;
    _hasValue = value != null;
  }

  private T _value;
  public T Value
  {
    get
    {
      return _value;
    }
  }
  
  private bool _hasValue;
  public bool HasValue
  {
    get
    {
      return _hasValue;
    }
  }

  public override string ToString()
  {
    if (!_hasValue)
      return "";

    return _value.ToString();
  }
}