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

private void BindToComboBox()
{
    List<string> items = new List<string>();
    items.Add("Hello");
    items.Add("Hello 1");
    items.Add("Hello 2");
    items.Add("Hello 3");
    items.Add("Hello 4");

    cboList.Items.AddRange(items.ToArray());
    cboList.Items.Insert(0, " ");
}

SqlConnection MyConnection = new SqlConnection(PublicVars.ConnectionString);
                MyConnection.Open();

                SqlDataAdapter sqlDA1 = new SqlDataAdapter("SELECT ItemID FROM some_items", MyConnection);
                DataSet sqlDS = new DataSet();

                sqlDA1.Fill(sqlDS, "some_items");
                DataTable tblItems= sqlDS.Tables["some_items"];

                DataRow NewRow = tblItems.NewRow();
                NewRow[0] = "-- Click To Select --";
                tblItems.Rows.InsertAt(NewRow, 0);

                cboItems.DataSource = tblItems;
                cboItems.DisplayMember = "ItemID";
                cboItems.ValueMember = "ItemID";
                cboItems.SelectedIndex = 0;

                MyConnection.Dispose();