title: Server error in application - cannot find table 0
body: <p>While deploying an ASP.NET application in IIS 7, im getting error:</p>
  
  <pre><code>Server Error in '/' Application
  
  Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 
  </code></pre>
  
  <p>Exception Details: System.IndexOutOfRangeException: Cannot find table 0.</p>
  
  <pre><code> Source Error: 
      Line 46:             dsDesignation= GetChartData("select * from LHSDesignation");
      Line 47: 
      Line 48:             if (dsDesignation != null &amp;&amp; dsDesignation.Tables[0].Rows.Count &gt; 0)
      Line 49:             {
      Line 50:                 foreach (DataRow dr in dsDesignation.Tables[0].Rows)
  
  
      Source File: D:\Raji\LHS\LHS\Chart.aspx.cs    Line: 48 
  
  Stack Trace: 
  
  [IndexOutOfRangeException: Cannot find table 0.]
     System.Data.DataTableCollection.get_Item(Int32 index) +95
     LHS.Chart.Page_Load(Object sender, EventArgs e) in D:\Raji\LHS\LHS\Chart.aspx.cs:48
     System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
     System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
     System.Web.UI.Control.OnLoad(EventArgs e) +91
     System.Web.UI.Control.LoadRecursive() +74
     System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2207
  </code></pre>
  
  <p>And the code for Page load is:</p>
  
  <pre><code>protected void Page_Load(object sender, EventArgs e)
          {
              string tmpDesignation = string.Empty;
              conString =Convert.ToString(ConfigurationManager.AppSettings["conString"]);
              strDesignation = Convert.ToString(ConfigurationManager.AppSettings["Designation"]);
              conection = new SqlConnection(conString);
  
              if (HttpContext.Current.Session["UserLogin"] != null)
              {
                  ClientScript.RegisterStartupScript(this.GetType(), "", "$.prompt('Please login to Update Score')", true);
              }
  
              dsDesignation= GetChartData("select * from LHSDesignation");
  
              if (dsDesignation != null &amp;&amp; dsDesignation.Tables[0].Rows.Count &gt; 0)
              {
                  foreach (DataRow dr in dsDesignation.Tables[0].Rows)
                  {
                      dnDesignatin.Add(Convert.ToString(dr["DesignationName"]), Convert.ToString(dr["TargetScore"]));
                  }
              }            
  </code></pre>
  
  <p>Please help me in resolving this error
  What need to be done to run in IIS 7?</p>