ASP.NET

private void SaveImageToDb(Stream imgStream, string contentType, int byteLength) {
    string sql = "INSERT INTO sysTmpImg_TempImage (sysTmp_recno, sysTmp_contentType, sysTmp_image) VALUES(@recno,  contentType, @image)";

    SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["myPetDb"].ConnectionString);
    SqlCommand com = new SqlCommand(sql, conn); 

    byte[] biImage = new byte[byteLength];
    imgStream.Read(biImage, 0, byteLength);

    com.Parameters.Add(new SqlParameter("@recno", Session.SessionID));
    com.Parameters.Add(new SqlParameter("@contentType", contentType));
    com.Parameters.Add(new SqlParameter("@image", biImage));

    if (conn.State != ConnectionState.Open) {
        conn.Open();
    }

    com.ExecuteNonQuery();

    conn.Close();
    com.Dispose();
    imgStream.Dispose();

    LoadImage(Session.SessionID);
}

public void AddNewTempImage(int usRecno, string tmpRecno, Stream imageStream, string contentType, int byteLength) {
    byte[] byteImage = new byte[byteLength];
    imageStream.Read(byteImage, 0, byteLength);

    string sql = "INSERT INTO sysTmpImg_TempImage (sysTmp_recno, sysTmp_US_recno, sysTmp_contentType, sysTmp_image) VALUES(@tmpRecno, @usRecno, @contentType, @image)";

    SqlCommand com = DataHelper.GetCommand(sql);
    com.Parameters.Add(new SqlParameter("@tmpRecno", tmpRecno));
    com.Parameters.Add(new SqlParameter("@usRecno", usRecno));
    com.Parameters.Add(new SqlParameter("@contentType", contentType));
    com.Parameters.Add(new SqlParameter("@image", byteImage));

    DataHelper.ExecuteNonQuery(com);

    imageStream.Dispose();
}

internal static class DataHelper
{
    public static DataSet Execute(SqlCommand command) {
        DataSet result = new DataSet();
        SqlDataAdapter adap = new SqlDataAdapter(command);
        adap.Fill(result);

        return result;
    }

    public static void ExecuteNonQuery(SqlCommand command) {
        CheckConnection(command.Connection);

        command.ExecuteNonQuery();
        command.Connection.Close();
    }

    public static object ExecuteScalar(SqlCommand command) {
        object result = null;
        CheckConnection(command.Connection);
        result = command.ExecuteScalar();
        command.Connection.Close();

        return result;
    }

    public static SqlCommand GetCommand() {
        return GetCommand(string.Empty);
    }

    public static SqlCommand GetCommand(string commandText) {
        SqlCommand result = new SqlCommand(commandText, GetConnection());
        //result.CommandType = CommandType.Text;

        return result;
    }

    private static void CheckConnection(SqlConnection connection) {
        if (connection.State == ConnectionState.Closed) {
            connection.Open();
        }
    }

    private static SqlConnection GetConnection() {
        ConnectionStringSettings connString = ConfigurationManager.ConnectionStrings["mainDb"];

        return new SqlConnection(connString.ConnectionString);
    }
}