Object Reference Not set to an instance error after deploying the code

Question

I am using asp.net GridView for displaying data, I have 9 columns coming from Database,from which I have to hide last two columns and records of those. I am using GridView RowDatabound event for hiding the columns and records. Its working fine when I am running my application from VS, even when I publish it on local IIS, it is working fine, but when I deployed it live, its giving following exception:

Object reference not set to an instance

I am using same database for both publishes Here's my code

        <asp:GridView ID="GridView1" runat="server" OnRowDataBound="GridView1_RowDataBound">
                                </asp:GridView>




        protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            if (e.Row.RowType == DataControlRowType.DataRow)
            {

                GridView1.HeaderRow.Cells[7].Visible = false;
                GridView1.HeaderRow.Cells[8].Visible = false;
                e.Row.Cells[7].Visible = false;
                e.Row.Cells[8].Visible = false;               
            }
        }

Databinding is done with DataTable

     var data = MyClass.GetHistory();//it returns DataTable
     GridView1.DataSource = data;
     GridView1.DataBind();

On which line exactly? http://stackoverflow.com/questions/4660142/what-is-a-nullreferenceexception-and-how-do-i-fix-it — Soner Gönül, Apr 09 '14 at 06:24
Data coming from datasource may not be the same if you are connecting to a different server when you publish it. — Kuzgun, Apr 09 '14 at 06:26
Most probably your application cannot connect to the DB on the deployment server. — johnpili, Apr 09 '14 at 06:26
May be an issue with different data sets in local and production? That could be a reason for exceptions in the prod server, when it is working fine locally in IIS — LakshmiNarayanan, Apr 09 '14 at 06:32
@LakshmiNarayanan both databases are same, I am checking with same user login — Syed Salman Raza Zaidi, Apr 09 '14 at 06:38
Almost all cases of `NullReferenceException` are the same. Please see "[What is a NullReferenceException in .NET?](http://stackoverflow.com/questions/4660142/what-is-a-nullreferenceexception-in-net)" for some hints. — John Saunders, Apr 09 '14 at 07:03

score 0 · Accepted Answer · answered Apr 09 '14 at 06:41

0

If I am correct, you are trying to hide columns 7 and 8, then do it after you bound the datasource as,

GridView1.Columns[7].Visible = false;
GridView1.Columns[8].Visible = false;

answered Apr 09 '14 at 06:41

Bharadwaj

2,535
1
22
35

Object Reference Not set to an instance error after deploying the code

1 Answers1