IndexOutOfRangeException
Hi there.
This works fine when I execute the sproc in Query Analyzer. But on the ASP.NET page it gives me an "IndexOutOfRangeException".
I am trying to figure out why. Thanks.
SqlConnection cnSearchDetails = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
SqlCommand cmdSearchDetails = new SqlCommand("GetProjectDetails", cnSearchDetails);
cmdSearchDetails.CommandType = CommandType.StoredProcedure;
cmdSearchDetails.Parameters.Add("@ProjectID", Int32.Parse(Request.QueryString["ProjectID"]));
cnSearchDetails.Open();
SqlDataReader drSearchDetails = cmdSearchDetails.ExecuteReader();
drSearchDetails.Read();
lblCluster.Text = drSearchDetails["ClusterName"].ToString();
lblSubCluster.Text = drSearchDetails["SubClusterName"].ToString();
lblArea.Text = drSearchDetails["AreaName"].ToString();
lblGroup.Text = drSearchDetails["GroupName"].ToString();
lblProjectNumber.Text = drSearchDetails["ProjectNumber"].ToString();
lblTitle.Text = drSearchDetails["Title"].ToString();
lblStartDate.Text = drSearchDetails["StartDate"].ToString();
lblEndDate.Text = drSearchDetails["EndDate"].ToString();
lblContinuation.Text = drSearchDetails["ContinuationNumber"].ToString();
lblAbstract.Text = drSearchDetails["Abstract"].ToString();
lblNotes.Text = drSearchDetails["Notes"].ToString();
lblGrantee.Text = drSearchDetails["GranteeName"].ToString();
lblSubject.Text = drSearchDetails["Subject"].ToString();
lblCommunities.Text = drSearchDetails["CommunityName"].ToString();
lblDirector.Text = drSearchDetails["Name"].ToString();
drSearchDetails.Close();
cnSearchDetails.Close();
|
