Server error in application - cannot find table 0

[McCainkickedObamasAzz]

While deploying an ASP.NET application in IIS 7, im getting error:\[code\]Server Error in '/' ApplicationDescription: 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\]Exception Details: System.IndexOutOfRangeException: Cannot find table 0.\[code\] Source Error: Line 46: dsDesignation= GetChartData("select * from LHSDesignation"); Line 47: Line 48: if (dsDesignation != null && dsDesignation.Tables[0].Rows.Count > 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\]And the code for Page load is:\[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 && dsDesignation.Tables[0].Rows.Count > 0) { foreach (DataRow dr in dsDesignation.Tables[0].Rows) { dnDesignatin.Add(Convert.ToString(dr["DesignationName"]), Convert.ToString(dr["TargetScore"])); } } \[/code\]Please help me in resolving this errorWhat need to be done to run in IIS 7?