I have written a method that is meant to return a dataset from a SQL
Server table (or not if there is nothing there to return). My app
regularly times out and crashes at this point and I don't know why.
Here is my method :
public DBResult Get_Prepay_Dataset(out DataSet dsPrepay, string strCUG,
string strSubcugPrepayQuery, DateTime dtmStartDatePrepayQuery, DateTime
dtmEndDatePrepayQuery)
{
DBResult dbrGetPrepayDataset;
string strGetPrepayDataset;
if (strSubcugPrepayQuery != "")
{
strGetPrepayDataset = "SELECT INCEPTTIME, STARTTIME, ENDTIME,
RTRIM(ODN) AS 'ODN', RTRIM(OOLI) AS 'OOLI' FROM RSP_LOG WITH (NOLOCK)
WHERE CUG = '" + strCUG + "' AND SUB_CUG = '" + strSubcugPrepayQuery +
"' AND STARTTIME BETWEEN '" + dtmStartDatePrepayQuery + "' AND '" +
dtmEndDatePrepayQuery + "'";
}
else
{
strGetPrepayDataset = "SELECT INCEPTTIME, STARTTIME, ENDTIME,
RTRIM(ODN) AS 'ODN', RTRIM(OOLI) AS 'OOLI' FROM RSP_LOG WITH (NOLOCK)
WHERE CUG = '" + strCUG + "' AND STARTTIME BETWEEN '" +
dtmStartDatePrepayQuery + "' AND '" + dtmEndDatePrepayQuery + "'";
}
SqlConnection objConnection = new
SqlConnection(ConfigurationSettings.AppSettings["strConnectHomelinkTest"
]);
dsPrepay = new DataSet();
try
{
SqlDataAdapter objAdapter = new SqlDataAdapter(strGetPrepayDataset,
objConnection);
objAdapter.Fill(dsPrepay, "tblPrepay");
int intCount = dsPrepay.Tables["tblPrepay"].Rows.Count;
if (intCount > 0)
{
dbrGetPrepayDataset = DBResult.Valid;
}
else
{
dbrGetPrepayDataset = DBResult.Invalid;
}
}
catch
{
dsPrepay = null;
dbrGetPrepayDataset = DBResult.Error;
}
objConnection.Close();
return dbrGetPrepayDataset;
}
Can anybody find something I am doing wrong in my code? Any help would
be really appreciated.
Cheers,
Mike
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!