A
Amy
I'm getting a System.StackOverflowException, and I can't see why.
Here's the code that's throwing the exception. I don't see anyting
that's recursive about it. Any help is appreciated (including help in
debugging - I'm not sure what I'd put in a try or catch clause here):
DataDealings sql = new DataDealings();
myProject = sql.GetProject(pID);
-------------------------------------------------------------------------------------
public Project GetProject (int pID)
{
Project p = new Project();
p = null;
SqlCommand cmdGetProject = new SqlCommand("PC_Return_Project", conn);
cmdGetProject.CommandType = CommandType.StoredProcedure;
cmdGetProject.Parameters.Add("@pID", pID);
conn.Open();
drProject = cmdGetProject.ExecuteReader();
if (drProject.Read())
{
p = new Project();
p.ProjName = drProject["projName"].ToString();
p.ProjDescrip = drProject["description"].ToString();
p.ProjRequestedDeadline = drProject["requestedDeadline"].ToString();
p.ProjBasecampURL = drProject["basecampURL"].ToString();
p.ProjStatus = drProject["Status"].ToString();
p.ProjStatusID = Int32.Parse(drProject["statusID"].ToString());
p.ProjFreq = drProject["freqtype"].ToString();
p.ProjFreqID = Int32.Parse(drProject["freqID"].ToString());
p.ProjPriority = drProject["priority"].ToString();
p.ProjPriorityID = Int32.Parse(drProject["priorityID"].ToString());
p.ProjDateProposed = drProject["dateProposed"].ToString();
drProject.Close();
conn.Close();
}
return p;
}
Here's the code that's throwing the exception. I don't see anyting
that's recursive about it. Any help is appreciated (including help in
debugging - I'm not sure what I'd put in a try or catch clause here):
DataDealings sql = new DataDealings();
myProject = sql.GetProject(pID);
-------------------------------------------------------------------------------------
public Project GetProject (int pID)
{
Project p = new Project();
p = null;
SqlCommand cmdGetProject = new SqlCommand("PC_Return_Project", conn);
cmdGetProject.CommandType = CommandType.StoredProcedure;
cmdGetProject.Parameters.Add("@pID", pID);
conn.Open();
drProject = cmdGetProject.ExecuteReader();
if (drProject.Read())
{
p = new Project();
p.ProjName = drProject["projName"].ToString();
p.ProjDescrip = drProject["description"].ToString();
p.ProjRequestedDeadline = drProject["requestedDeadline"].ToString();
p.ProjBasecampURL = drProject["basecampURL"].ToString();
p.ProjStatus = drProject["Status"].ToString();
p.ProjStatusID = Int32.Parse(drProject["statusID"].ToString());
p.ProjFreq = drProject["freqtype"].ToString();
p.ProjFreqID = Int32.Parse(drProject["freqID"].ToString());
p.ProjPriority = drProject["priority"].ToString();
p.ProjPriorityID = Int32.Parse(drProject["priorityID"].ToString());
p.ProjDateProposed = drProject["dateProposed"].ToString();
drProject.Close();
conn.Close();
}
return p;
}