exception; object reference not set to an instance of an object

[Eric Sabine]

very easy I'm sure...

On the return statement, I get the object reference not set to an instance
of an object exception. I fully typed out the object paths for clarity,
i.e., the application blocks and the configuration settings.

thank, Eric
private int LogTransfer(string FileName, string Email, string UserName,
int Direction)
{
// Set up our 4 parameters
SqlParameter[] arParms = new SqlParameter[4];
arParms[0] = new SqlParameter("@filename", SqlDbType.VarChar, 200 );
arParms[0].Value = FileName;
arParms[1] = new SqlParameter("@email", SqlDbType.VarChar, 200);
arParms[1].Value=Email;
arParms[2] = new SqlParameter("@ssiuser", SqlDbType.VarChar, 200);
arParms[2].Value=UserName;
arParms[3] = new SqlParameter("@type", SqlDbType.SmallInt );
arParms[3].Value= Direction;

return (int)Microsoft.ApplicationBlocks.Data.SqlHelper.Ex ecuteScalar(

System.Configuration.ConfigurationSettings.AppSett ings.Get("ConnectionString
"),
CommandType.StoredProcedure,
"webdata.dbo.usp_di_webFileTransferLog",
arParms);
}

[Eric Sabine]

Thank you, I did not mention it but I also tried replacing the
AppSettings.Get() method with the connection string itself. The exception
did not stop.

Eric

Richard wrote:

You'll get the exception if your AppSettings files doesn't have an
entry for "ConnectionString"... --> Case sensitive and spelled
correctly else null is returned...

--Richard

"Eric Sabine" wrote:

very easy I'm sure...

On the return statement, I get the object reference not set to an
instance of an object exception. I fully typed out the object paths
for clarity, i.e., the application blocks and the configuration
settings.

thank, Eric
private int LogTransfer(string FileName, string Email, string
UserName, int Direction)
{
// Set up our 4 parameters
SqlParameter[] arParms = new SqlParameter[4];
arParms[0] = new SqlParameter("@filename", SqlDbType.VarChar, 200
); arParms[0].Value = FileName;
arParms[1] = new SqlParameter("@email", SqlDbType.VarChar, 200);
arParms[1].Value=Email;
arParms[2] = new SqlParameter("@ssiuser", SqlDbType.VarChar, 200);
arParms[2].Value=UserName;
arParms[3] = new SqlParameter("@type", SqlDbType.SmallInt );
arParms[3].Value= Direction;

return
(int)Microsoft.ApplicationBlocks.Data.SqlHelper.Ex ecuteScalar(

System.Configuration.ConfigurationSettings.AppSett ings.Get("ConnectionString "),
CommandType.StoredProcedure,
"webdata.dbo.usp_di_webFileTransferLog",
arParms);
}