C#

private DataTable CreateDataTable()
        {
            DataTable result = new DataTable();
            result.Columns.AddRange(new DataColumn[]{new DataColumn("ID", typeof(int)), new DataColumn("NAME")});
            return result;
        }

        public List<string[]> CreateList()
        {
            List<string[]> result = new List<string[]>();
            for (int i = 0; i < 100; i++)
            {
                string[] data = new string[] { string.Format("{0}", i + 1), string.Format("data_{0}", i + 1) };
                result.Add(data);
            }
            return result;
        }

        private void button1_Click(object sender, EventArgs e)
        {
            DataTable dtb = CreateDataTable();
            List<string[]> result = CreateList();
            for (int i = 0; i < result.Count; i++)
            {
                dtb.Rows.Add(result[i]);
            }
            dataGridView1.DataSource = dtb;
            try
            {
                string strExpression = "ID = 1";
                DataRow[] dr = dtb.Select(strExpression);                 MessageBox.Show(dr[0].ToString());
            }
            catch (Exception ex)
            {

                MessageBox.Show(ex.Message);
            }
        }

dhaim
programming is a hobby that make some money as side effect

R.A.C wrote:

I got an Exception with the excel file

R.A.C wrote:

windows 2000 had an old version of the MDAC

Mohammad Dayyan wrote:

Who can help

Eslam Afifi wrote:

And why do you want to substitute it? Lambda expressions feels more natural than delegates' syntax.