public static bool ExecuteStoredProc_stringParam(string spName, string param, string paramName, int size)
{
try
{
using (SqlConnection cn = new SqlConnection(DataAccess.connectionString))
{
cn.Open();
SqlCommand cmd = new SqlCommand(spName, cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 600;
cmd.Parameters.Add(new SqlParameter(paramName,
SqlDbType.NVarChar, size));
cmd.Parameters[0].Value = param;
cmd.ExecuteNonQuery();
return(true);
}
}
catch (SqlException Sqlex)
{
Console.WriteLine("Database problem: ["
+ Sqlex.ToString() + "]");
return(false);
}
catch (Exception ex)
{
Console.WriteLine("[" + ex.ToString() + "]");
return(false);
}
}
public static object GetSingleValueSql(string sqlString)
{
try
{
using (SqlConnection cn = new SqlConnection(DataAccess.connectionString))
{
cn.Open();
SqlCommand cmd = new SqlCommand(sqlString, cn)
{
CommandType = CommandType.Text
};
return(cmd.ExecuteScalar());
}
}
catch (SqlException Sqlex)
{
Console.WriteLine("Database problem: ["
+ Sqlex.ToString() + "]");
return(-1);
}
catch (Exception ex)
{
Console.WriteLine("[" + ex.ToString() + "]");
return(-1);
}
}
