Validation in datatable
<p>here i am putting a bulk data in table of more then 5000+ </p>

<pre><code>  using (OleDbConnection excel_con = new OleDbConnection(conString))
        {
            excel_con.Open();
            string sheet1 = excel_con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null).Rows[0]["TABLE_NAME"].ToString();
            DataTable dtExcelData = new DataTable();





            dtExcelData.Columns.AddRange(new DataColumn[10] {

//this are my columns of records

            new DataColumn("Employee Code",typeof(string)),
            new DataColumn("Employee Type", typeof(int)),
            new DataColumn("First Name", typeof(string)),
            new DataColumn("Last Name", typeof(string)),
            new DataColumn("Gender",typeof(string)),
            new DataColumn("Email ID", typeof(string)),
            new DataColumn("Mobile No#", typeof(string)),
            new DataColumn("Current Address", typeof(string)),
            new DataColumn("Permanent Address", typeof(string)),
            new DataColumn("Status",typeof(string))
        }
            );


            using (OleDbDataAdapter oda = new OleDbDataAdapter("SELECT * FROM [" + sheet1 + "]", excel_con))
            {
                oda.Fill(dtExcelData);


            }
            excel_con.Close();
</code></pre>

<p>now before inserting or after insert in datatable 
i want to check validation of Mobile No,Email ID,Gender,null value etc </p>