Import Excel Data To Gridview Using C#

Create Form

public string strFileName;

private void excelBrowsebtn_Click(object sender, EventArgs e)
        {
            strFileName = txtFileName.Text;
            OpenFileDialog fdlg = new OpenFileDialog();
            fdlg.Title = "Select file";
            fdlg.InitialDirectory = @"c:\";
            fdlg.FileName = txtFileName.Text;
            fdlg.Filter = "Excel Sheet(*.xlsx)|*.xls|All Files(*.*)|*.*";
            fdlg.FilterIndex = 1;
            fdlg.RestoreDirectory = true;
            if (fdlg.ShowDialog() == DialogResult.OK)
            {
                txtFileName.Text = fdlg.FileName;
            }

string connectionString = String.Format(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};
Extended Properties=""Excel 8.0;HDR=YES;IMEX=1;""", txtFileName.Text);
string query = String.Format("select * from [{0}$]", "Sheet1");
OleDbDataAdapter dataAdapter = new OleDbDataAdapter(query, connectionString);
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet);
dataGridView1.DataSource = dataSet.Tables[0];
        }

private void dataGridView1_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e)
        {
            if (e.Control is System.Windows.Forms.TextBox)
            {
                ((System.Windows.Forms.TextBox)e.Control).CharacterCasing = CharacterCasing.Upper;
            }
        }

Alternative Row Color in HTML Table Using CSS

table tr:nth-child(odd){background-color: green; }

table tr:nth-child(even){background-color: red; }