When import exel file on the server getting error,,,,

i am currenlty building website in asp.net2.0
in which i emport excel file into gridview
when iam running this code in localhost iam able to emport excel data to Gridview .
but when iam runnign the same in my online server it is not getting emport instead its giving an error
'object reference not set to an instance of an object'
i am not able to find it out the errror.
i also tried with dubugging but no such error is occuring but why its this error while in online.
the below is my code where emport excel file into Gridview.

plz Write aproprite code.

public void BindGridView()
    {
       // string FilePath = ResolveUrl("./Upload/"); // Give Upload File Path
        string FilePath = Server.MapPath("./Upload/");
        string filename = string.Empty;
        if (FileUpload1.HasFile) // Check FileControl has any file or not
        {
            try
            {
                string[] allowdFile = { ".xls", ".xlsx" };
                string FileExt = System.IO.Path.GetExtension(FileUpload1.PostedFile.FileName).ToLower();// get extensions
                bool isValidFile = allowdFile.Contains(FileExt);

                // check if file is valid or not
                if (!isValidFile)
                {
                    lblMsg.Visible = true;
                    lblMsg.Style.Add("color", "red");
                    lblMsg.Text = "Please upload only Excel";
                }
                else
                {
                    int FileSize = FileUpload1.PostedFile.ContentLength; // get filesize
                    if (FileSize <= 1048576) //1048576 byte = 1MB
                    {
                        //filename = Path.GetFileName(Server.MapPath(FileUpload1.FileName));// get file name
                        //FileUpload1.SaveAs(Server.MapPath(FilePath) + filename); // save file to uploads folder
                        //string filePath = Server.MapPath(FilePath) + filename;

                        filename = Path.GetFileName(Server.MapPath(FileUpload1.FileName));// get file name
                        FileUpload1.SaveAs(FilePath + filename);// save file to uploads folder


                        string filePath = FilePath + filename;

                        string conStr = "";
                        if (FileExt == ".xls") // check for excel file type
                        {
                            conStr = ConfigurationManager.ConnectionStrings["Excel03ConString"].ConnectionString;
                        }
                        else if (FileExt == ".xlsx")
                        {
                            conStr = ConfigurationManager.ConnectionStrings["Excel07ConString"].ConnectionString;
                        }

                        conStr = String.Format(conStr, filePath, "Yes");
                        OleDbConnection con = new OleDbConnection(conStr);
                        OleDbCommand ExcelCommand = new OleDbCommand();
                        ExcelCommand.Connection = con;
                        con.Open();
                        DataTable ExcelDataSet = new DataTable();
                        ExcelDataSet = con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
                        DataTable dt = new DataTable();
                        if (ExcelDataSet != null && ExcelDataSet.Rows.Count > 0)
                        {
                            string SheetName = ExcelDataSet.Rows[0]["TABLE_NAME"].ToString(); // get sheetname
                            ExcelCommand.CommandText = "SELECT * From [" + SheetName + "]";
                            OleDbDataAdapter ExcelAdapter = new OleDbDataAdapter(ExcelCommand);
                            ExcelAdapter.SelectCommand = ExcelCommand;
                            ExcelAdapter.Fill(dt);
                        }
                        Tr_Heading.Attributes.Add("style", "display:none");
                        con.Close();
                        if (dt != null && dt.Rows.Count > 0) // Check if File is Blank or not
                        {
                            gvSubscriberProject.DataSource = dt;
                            gvSubscriberProject.DataBind();
                            lblMsg.Visible = false;
                        }
                        else
                        {

                            lblMsg.Visible = true;
                            lblMsg.Style.Add("color", "red");
                            lblMsg.Text = "There are No Rows in this File!!!";
                        }
                        FilePath = ResolveUrl("~/Upload/");
                        string fileName = Server.MapPath(FilePath) + filename;
                        FileInfo f = new FileInfo(fileName);
                        if (f.Exists)
                        {
                            f.IsReadOnly = false;
                            f.Delete();
                        }
                    }
                    else
                    {
                        lblMsg.Visible = true;
                        lblMsg.Style.Add("color", "red");
                        lblMsg.Text = "Attachment file size should not be greater then 1 MB!";
                    }
                }
            }
            catch (Exception ex)
            {
                lblMsg.Visible = true;
                lblMsg.Style.Add("color", "red");
                lblMsg.Text = "Error occurred while uploading a file: " + ex.Message;
            }
        }
        else
        {
            lblMsg.Visible = true;
            lblMsg.Style.Add("color", "red");
            lblMsg.Text = "Please select a file to upload.";
        }
    }

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kunal Vaishya11y ago
Please use FileUpload1.SaveAs method only once.
Wim Sturkenboom11y ago
Expand your catch a little so it will tell you what is wrong; e.g.

            catch (Exception ex)
            {
                lblMsg.Visible = true;
                lblMsg.Style.Add("color", "red");
                lblMsg.Text = "Error occurred while uploading a file: " + ex.StackTrace;
            }

Alternatively, break your code in smaller pieces, each embedded in a try/catch; that way it also might be easier to find the culprit.