I have completed fetch 100 row data from excel file and store in data base but I can't read 3rd row data FN3VCAP3250 and can't store in database.

See more:

C#

Javascript

.NET

Ajax

MVC

jQuery

I have completed fetch 100 row data from excel file and storein data base but I can't read 3rd row data FN3VCAP3250 value and can't store in database. because its show in dataset is null.
Please help me, It's Urgent.



008837-VibramycinSyrup 207565 375.32

037234-Derma3TwistCapLarge 207560 60.17

008836-VibramycinSuspension FN3VCAP3250 34.07


Use this Code-:

if (flUpload.HasFile)
                {
                    string path = Server.MapPath("~/Administrator/UploadedExcelFile/");
                    flUpload.SaveAs(path + flUpload.FileName);
                    string path1 = Server.MapPath("~/Administrator/UploadedExcelFile/" + flUpload.FileName);

                    OleDbConnection MyConnection = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source='" + path1 + "';Extended Properties=Excel 12.0;");
                    OleDbDataAdapter MyCommand = new System.Data.OleDb.OleDbDataAdapter("select * from [Sheet1$]", MyConnection);
                    DtSet = new System.Data.DataSet();

                    //Bind all excel data in to data set
                    MyCommand.Fill(DtSet, "[Sheet1$]");
                    DataTable dt = new DataTable();
                    dt = DtSet.Tables[0];
                    MyConnection.Close();
                    //ViewState["myTable"] = dt;
                    if (dt != null)
                    {
                        foreach (DataRow dr in dt.Rows)
                        {
}
}